computed column in proc report

[mlogan]

Can someone tell me why my ratio variable doesn't show any value. Thanks,

proc report data=sashelp.class nowindows headline headskip;

columns name sex age height weight ratio;

define name / display 'Name' width=10;

define sex / group 'Sex' width=6;

define age / analysis mean 'Age' width=4;

define height / analysis mean 'Height' format=8.1;

define weight / analysis mean 'Wight' format=8.1;

define ratio / computed format=6.2;

compute ratio;

ratio = height/Weight;

endcompute;

break after sex / ol  summarize skip suppress;

rbreak after/summarize dol dul;

run;

[Cynthia_sas · Accepted solution]

HI:

  Proc REPORT requires a "compound name" when you use ANALYSIS variables in a COMPUTE block. So, for example, your current COMPUTE block does NOT use a compound name in the assignment statement of the form:

newvar = variable-name.statistic .... rest of expression;
    

  So your COMPUTE block should be:

compute ratio;

    ratio = height.mean/Weight.mean;

endcomp;

  There is a section in the doc about PROC REPORT that explains about the PROC REPORT and the compound name.

cynthia

[mlogan]

Thanks Cynthia, that's helpful.