Stuck on part C

[hundohoppip]

Im a brand new sas user. Im suppose to do the following but Im stuck on part C.

Calculate total points of homework and quizzes 

a. Subset homework and quizzes from class data sets as HQ data sets (say, HQ1, etc.) along with 
student ID variable. 
b. Use Proc Transpose to transpose the data set HQ1 by student_ID, so we can rank (or sort) 
homework and quizzes scores for each student later. 


c. Keep only two variables: student ID and “scores of homework and quizzes” from Proc 
transpose. 

d. Sort the resulting data set in step c such that each student’s 17 to 20 scores of homework and 
quizzes are ranked from high to low 

e. Transpose data back into the original format, and don’t worry about variable names

code attached

[ballardw · Accepted solution]

---

@hundohoppip wrote:

Im a brand new sas user. Im suppose to do the following but Im stuck on part C.

Calculate total points of homework and quizzes 

a. Subset homework and quizzes from class data sets as HQ data sets (say, HQ1, etc.) along with 
student ID variable. 
b. Use Proc Transpose to transpose the data set HQ1 by student_ID, so we can rank (or sort) 
homework and quizzes scores for each student later. 


c. Keep only two variables: student ID and “scores of homework and quizzes” from Proc 
transpose. 

d. Sort the resulting data set in step c such that each student’s 17 to 20 scores of homework and 
quizzes are ranked from high to low 

e. Transpose data back into the original format, and don’t worry about variable names

code attached

---

Any time you create a data set in SAS you can add options to Keep or Drop variables.

An example you should be able to run:

Proc sort data=sashelp.class
              out= work.class(keep= name sex age)
;
   by sex age;
run;

The options go inside parentheses after the name of the data set. The data set options can be used with just about any data set. There are some interactions between Keep/ Drop and Rename (yes you can change the name of variable just before/after use) in the same option as to which name to keep when renaming.