topic PROC MEANS in SAS Programming

PROC MEANS

BrandonBayles — Tue, 26 Feb 2019 06:03:52 GMT

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;

Re: PROC MEANS

PeterClemmensen — Tue, 26 Feb 2019 06:09:56 GMT

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.

Re: PROC MEANS

BrandonBayles — Tue, 26 Feb 2019 06:14:37 GMT

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

Re: PROC MEANS

PeterClemmensen — Tue, 26 Feb 2019 06:18:30 GMT

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

Re: PROC MEANS

Astounding — Tue, 26 Feb 2019 10:31:44 GMT

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

PROC MEANS ... NONOBS NWAY;

Re: PROC MEANS

BrandonBayles — Tue, 26 Feb 2019 19:12:51 GMT

Sorry, I misspoke. This worked thank you.