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.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.