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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.