BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
mlogan
Lapis Lazuli | Level 10

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;

1 ACCEPTED SOLUTION

Accepted Solutions
Cynthia_sas
SAS Super FREQ

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

2 REPLIES 2
Cynthia_sas
SAS Super FREQ

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

mlogan
Lapis Lazuli | Level 10

Thanks Cynthia, that's helpful.

sas-innovate-2024.png

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.

 

Register now!

How to choose a machine learning algorithm

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.

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