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;
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
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
Thanks Cynthia, that's helpful.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.