Using SAS

link to excel file:

https://docs.google.com/spreadsheets/d/1cHOgMt1qiGMzPFLW7EvTPm4OIVQvqT3fHZXi8mcmaf0/edit?usp=sharing

9. Use code to import Excel data. a. Write the SAS code to import data from the Excel file FAMILY.XLSX using these criteria: I. Create a SAS data set named INCOME in the WORK library using the OUT- statement. 1. Use DATAFILE= to specify the location of the original Excel file on your hard disk 11. Use DBMS= to specify that the data source is XLS . IV. Use RANGEto designate 'Data$A1:E76'as the name of the Excel table to V. Use the GETNAMES= option to indicate that the variable names are on the first row of data. b. Once the data are imported, view the contents of wORK. INCOME using yiewdata. close the iewdt data grid. c. Calculate descriptive statistics for the data using this code TITLE "PUT YOUR NAME HERE"; PROC MEANS DATA-INCOME; RUN; 9. Use code to import Excel data. a. Write the SAS code to import data from the Excel file FAMILY.XLSX using these criteria: I. Create a SAS data set named INCOME in the WORK library using the OUT- statement. 1. Use DATAFILE= to specify the location of the original Excel file on your hard disk 11. Use DBMS= to specify that the data source is XLS . IV. Use RANGEto designate 'Data$A1:E76'as the name of the Excel table to V. Use the GETNAMES= option to indicate that the variable names are on the first row of data. b. Once the data are imported, view the contents of wORK. INCOME using yiewdata. close the iewdt data grid. c. Calculate descriptive statistics for the data using this code TITLE "PUT YOUR NAME HERE"; PROC MEANS DATA-INCOME; RUN