PROC MEANS

[BrandonBayles]

Hello new to SAS. Using one PROC MEAN step I'm trying to do the following two things.... calculate the total score and percent for each

student using the code seen below and calculate the student's score and percentage for each of the five domain categories. But the output is not quite what it needs to be. Every time I run the code I get a data set the excludes the means as seen in the first picture. Any help would be great. Thanks. 

PROC MEANS DATA = COMBINED MEAN SUM NONOBS;
     VAR Scores ;
     CLASS Student DomainNum;
     ID Form ;
     OUTPUT OUT=COMBINED_TABLE (DROP= _TYPE_ _FREQ_) SUM=score MEAN = score;
RUN;

[PeterClemmensen]

Rename your mean variable in your Output Statement. Right now, you try to name two variables to 'score', so only the first one catches on.

[BrandonBayles]

That helped but my table is still not quite there. Here is what it now looks like.....

[PeterClemmensen]

And what is wrong with this? Please be more specific 🙂

[BrandonBayles]

Sorry, I misspoke. This worked thank you. 

[Astounding]

At least one step closer: add NWAY to the end of the first statement:

PROC MEANS ... NONOBS NWAY;