01-30-2013 05:36 PM
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;
BREAK AFTER SCHOOLCODE / SUMMARIZE ;
01-30-2013 06:06 PM
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.