Question: 2 (15 points): Import Demographics Data The demographics.txt data is a fixed-width text file containing the donors' demographical information. The names and descriptions of the
2 (15 points): Import Demographics Data The demographics.txt data is a fixed-width text file containing the donors' demographical information. The names and descriptions of the columns of this data are given in Table 1. Table 1: Variables in Demographics Data Name Description ID Control Number DemAge Age DemCluster Demographic Cluster DemGender Gender DemHomeOwner Home Owner DemMedHomeValue Median Home Value DemMedIncome Median Income Use the Import Data task in SAS Enterprise Guide to complete the following: a) Change the output SAS dataset name to demographics and save this file in the WORK library. (2 pts) b) Change the variable names in the output SAS data set using the names in Table 1 and label them with the descriptions in Table 1. (2 pts) c) Change the length of DemGender and DemHomeOwner to be 1. (2 pts) d) Change the type of ID to be character. (2 pts) e) Do NOT embed the data and rename the task as Import Demographics. (2 pts) DA 6223 Homework 1 Spring 2024 2 f) Use the Summary Statistics task to obtain the following statistics: mean, standard deviation, minimum, maximum, and number of missing values for DemAge, DemMedHomeValue, and DemMedIncome by different levels of DemGender. Bb Q1) Based on the SAS Enterprise Guide result, summarize your findings into a table: Right-click on the HTML output of the Summary Statistics and select Share > Export. Save the resulting HTML output in your P:\drive to be uploaded on Canvas. (5 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
