Hi-
Can anyone help me with multiple compute statements within Proc Report? I cant seem to get it to work:
I am looking to compute the sum of FCODE within RACE by school. Thank you all!
PROC REPORT NOWD DATA=Q1 OUT=Q1A
NOFS HEADLINE HEADSKIP;
COLUMNS SCHOOLcODE RACE FCODE TOTAL;
DEFINE SCHOOLCODE / GROUP;
DEFINE RACE / DISPLAY;
DEFINE FCODE / DISPLAY;
DEFINE TOTAL/ ANALYSIS SUM;
COMPUTE AFTER SCHOOLCODE;
ENDCOMP;
BREAK AFTER SCHOOLCODE / SUMMARIZE ;
RUN;
Hi:
What are you trying to get to work? You have nothing in your COMPUTE block for SCHOOLCODE. I have already posted a response in your other question, that RACE needs to be ORDER or GROUP if you want to get a summary on it. If all you want is a summary line, you do not need a COMPUTE block, only a BREAK statement.
Also, I have a hard time visualizing what you want when you say that you want "sum of FCODE within RACE by school" -- do you want to see 1 summary row for every unique combination of SCHOOL/RACE/FCODE? or do you want to see each SCHOOL with the detail lines for RACE/FCODE and then have a summary at the end of the DETAIL lines.
I'd recommend that you study the documentation topic on ow PROC REPORT builds a report so you can understand the function of GROUP and ORDER with BREAK and COMPUTE.
cynthia
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.