Create and sort the Score data set. This data set contains test scores for students who took two tests and a final exam. The SORT procedure sorts the data set by the BY variables Section and Student.
data score; input Student Section Test1-Test3; stest1=test1; stest2=test2; stest3=test3; datalines; 238900545 1 94 91 87 254701167 1 95 96 97 238806445 2 91 86 94 999002527 2 80 76 78 263924860 1 92 40 85 459700886 2 75 76 80 416724915 2 66 69 72 999001230 1 82 84 80 242760674 1 75 76 70 990001252 2 51 66 91 ; run; proc sort data=score; by Section Student; run;