Proc report-calculated column

Ronein — Tue, 02 Oct 2018 05:23:09 GMT

Hello

Please see examples of proc report with "computed" column.

I have some questions related to example1 /example2 please:

Why do we use "analysis mean"? It is not calculating mean here.It just show the values.

I have some questions related to example3 please:

Why the total row is not calculated here?

/*Example1*/
proc report  data=sashelp.class   NOWD;
Columns name sex age height weight ratio;
DEFINE name / display "Name" width=10;
DEFINE sex / display "Gender" width=6; 
DEFINE age / display "Age" width=4;  
DEFINE height / analysis mean  "Height" format=8.1;  
DEFINE weight / analysis mean "Weight" format=8.1;  
Define ratio /computed format=6.2;

compute ratio;
ratio=height.mean/weight.mean;
endcomp;
rbreak after/summarize;
run;

 
/*Example2*/
proc report  data=sashelp.class   NOWD;
Columns name sex age height weight ratio;
DEFINE name / display "Name" width=10;
DEFINE sex / display "Gender" width=6; 
DEFINE age / display "Age" width=4;  
DEFINE height / analysis mean  "Height" format=8.1;  
DEFINE weight / analysis mean "Weight" format=8.1;  
Define ratio /computed format=6.2;

compute ratio;
ratio=_C4_/_C5_;
endcomp;
rbreak after/summarize;
run;



/*Example3*/
proc report  data=sashelp.class   NOWD;
Columns name sex age height weight ratio;
DEFINE name / display "Name" width=10;
DEFINE sex / display "Gender" width=6; 
DEFINE age / display "Age" width=4;  
DEFINE height / display  "Height" format=8.1;  
DEFINE weight / display "Weight" format=8.1;  
Define ratio /computed format=6.2;

compute ratio;
ratio=_C4_/_C5_;
endcomp;

rbreak after/summarize;
run;

Re: Proc report-calculated column

RW9 — Tue, 02 Oct 2018 07:54:21 GMT

q1) it is because you use the mean here:

height.mean/weight.mean;

q2) because mean is not calculated.

Re: Proc report-calculated column

Ksharp — Tue, 02 Oct 2018 10:54:52 GMT

You are using "

rbreak after/summarize;

topic Re: Proc report-calculated column in SAS Programming

Proc report-calculated column

Re: Proc report-calculated column

Re: Proc report-calculated column