Help using Base SAS procedures

Proc Report Compute

Reply
Contributor
Posts: 28

Proc Report Compute

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;

SAS Super FREQ
Posts: 8,743

Re: Proc Report Compute

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

Ask a Question
Discussion stats
  • 1 reply
  • 142 views
  • 0 likes
  • 2 in conversation