Create a data warehouse database, including the fact and dimension tables (star schema). Create the schema for each table. Populate the tables using either ETL (Pentaho) or SQL (PostgreSQL). Preprocessing for SAS: Extract data from the data warehouse, creating a file for input into SAS. The format of the file is your choice. Ensure SAS University Edition accepts your selected format. Statistical Analysis Using SAS: Import data created in the preprocessing step. Conduct statistical analysis using the appropriate statistics from each category: Summary statistics, Classification, Clustering, Association INSTRUCTIONS When you preform statistical analysis make sure that you include only the relevant output from SAS. Any irrelevant out in which you don’t explain will result in a deduction of points. Remember that you need to conduct: (a) Summary statistics; (b) Classification; (c) Clustering; and (d) Association. As mentioned in the Live Classroom session, you are to determine the appropriate variables. here is one way to do (binary) classification https://video.sas.com/detailivideo/5537523052001/the-binary-logistic-regression-task-in-sasS-studio (Links to an external site.)
Sample Solution
The post Statistical Analysis Report using PostgreSQL & SAS Studio appeared first on homework handlers.