You want the total row at the bottom, but it's current at the top. What this means is that you want to concatenate two data sets:
All the observations from want1 starting with the second obs. (firstobs=2)
The single first obs from want1 (obs=1)
The set statement does concatenation:
data want2;
set want1 (firstobs=2) want1 (obs=1);
run;
And "dot for total"? I don't see how you can get that. You can get a dot for the class variable (score1). But it can never have the value "TOTAL" because score1 is a numeric variable, and "TOTAL" is a character value. You can make a new character variable from SCORE1, such that when score1=dot, the new var gets "TOTAL". And all other values of score1 are stored in the new var as character values. I.e. if score1=. then newvar="Total"; else newvar=put(score1,5.1);
You can look up the PUT function to see how it works
... View more