topic Re: computed column in proc report in SAS Data Science

computed column in proc report

mlogan — Thu, 16 Jul 2015 14:44:36 GMT

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;

Re: computed column in proc report

Cynthia_sas — Thu, 16 Jul 2015 15:26:28 GMT

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

Re: computed column in proc report

mlogan — Thu, 16 Jul 2015 16:09:46 GMT

Thanks Cynthia, that's helpful.