Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

computed column in proc report

Accepted Solution Solved
Reply
Regular Contributor
Posts: 218
Accepted Solution

computed column in proc report

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;


Accepted Solutions
Solution
‎07-16-2015 11:26 AM
SAS Super FREQ
Posts: 8,862

Re: computed column in proc report

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

View solution in original post


All Replies
Solution
‎07-16-2015 11:26 AM
SAS Super FREQ
Posts: 8,862

Re: computed column in proc report

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

Regular Contributor
Posts: 218

Re: computed column in proc report

Posted in reply to Cynthia_sas

Thanks Cynthia, that's helpful.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 324 views
  • 0 likes
  • 2 in conversation