USE OF ANALYSIS OPTION

thanikondharish — Sun, 05 Aug 2018 11:39:34 GMT

proc report data=sashelp.class nowd;
columns name sex age height weight ;
define age/display ANALYSIS;
define height/display;
rbreak after/ summarize;
run;

WHAT IS THE USE OF ANALYSIS IN ABOVE DATA PROGRAM

Re: USE OF ANALYSIS OPTION

PeterClemmensen — Sun, 05 Aug 2018 11:43:24 GMT

See my answer to your related thread here.

Re: USE OF ANALYSIS OPTION

Cynthia_sas — Sun, 05 Aug 2018 15:37:59 GMT

Hi:
As @PeterClemmensen recommending, reading the PROC REPORT documentation will help you here. You only need 1 usage usually, with a variable in a PROC REPORT DEFINE statement. So if you want age to be summarized on the RBREAK, then you need the usage of ANALYSIS (and you will get the default analysis statistic of SUM). However, if you want AGE not to be included in any grand total summary line, then a usage of DISPLAY is appropriate.

Now, getting a summary of all the ages or all the heights doesn't make sense, and in your code, if you run it, you'll see that AGE and WEIGHT are summarized at the RBREAK, but HEIGHT (because it is a usage of DISPLAY) is NOT summarized.

Asking for the MEAN or MIN or MAX on the summary line would be more likely on a report that showed every detail row. You can achieve this by changing the statistic on the DEFINE statement. Oh, wait, you don't have a statistics, so you are getting the DEFAULT of SUM for AGE and WEIGHT.

See what happens if you do this:

proc report data=sashelp.class nowd;
columns name sex age height weight ;
define age/min ANALYSIS;
define height/display;
define weight / analysis min;
rbreak after/ summarize;
run;

Cynthia

topic USE OF ANALYSIS OPTION in SAS Programming

USE OF ANALYSIS OPTION

Re: USE OF ANALYSIS OPTION

Re: USE OF ANALYSIS OPTION