Proc Report Compute

SAS_new — Wed, 30 Jan 2013 22:36:17 GMT

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;

Re: Proc Report Compute

Cynthia_sas — Wed, 30 Jan 2013 23:06:03 GMT

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

topic Re: Proc Report Compute in SAS Procedures

Proc Report Compute

Re: Proc Report Compute