STAT:5400 Computing in Statistics Homework 9 Due: Wed. Dec. 5 A file called "simscores.txt" is in the Datasets section of the course web page. Submit all of your SAS code as a text file. The output may be submitted as either .txt, .pdf, or .html. 1. Read this data into SAS. 2. Use a data step to create a reformatted dataset and print it. The first 10 records should look like this: Obs id type score 1 001 reading 45 2 001 spelling 38 3 001 math 31 4 001 science 42 5 002 reading 56 6 002 spelling 60 7 002 math 62 8 002 science 49 9 003 reading 70 10 003 spelling 65 3. Use proc sql to extract the "science" scores from the new dataset you created in step 2. The output should look like this: score -------- 42 49 58 42 52 71 59 40 52 49 4. Use the appropriate SAS procedure to reformat the dataset you created in step 2 so that there is just one record per id. Print the new dataset. It should look like this: Obs id _NAME_ reading spelling math science 1 001 score 45 38 31 42 2 002 score 56 60 62 49 3 003 score 70 65 65 58 4 004 score 48 45 42 42 5 005 score 68 51 58 52 6 006 score 72 68 71 71 7 007 score 51 42 47 59 8 008 score 60 50 60 40 9 009 score 55 49 58 52 10 010 score 52 56 38 49