As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


Define multiple PROC REPORT items in one statement

From sasCommunity
Revision as of 19:04, 26 March 2016 by ArtCarpenter (Talk | contribs)

Jump to: navigation, search

Although the PROC REPORT documentation implies that only one "report item" can be referenced in a DEFINE statement, it appears that multiple items can be referenced using variable lists.

This can be useful, for instance, if you want an easy way to specify the same type for all items in your report:

define _all_ / display;

Or if you want to specify some other characteristic for a related group of items:

define DISP: / display width=....;

Other forms of variable lists also work.

define date1-date3 / display;
define edu--wt / display;

Interestingly a specific list of variables will not. The following DEFINE statement will cause errors.

define height weight /  analysis mean;

The DEFINE statement can also reference a statistic such as MEAN. If there is more than one mean being calculated, it is possible to apply the DEFINE statement to more than one column of means.

proc report data=sashelp.class nowd;
 column sex (height weight),mean;
 define sex  / group;
 define mean / format=6.1;
 run;

As you might surmise, these same lists can be utilized in the COLUMN statement.

column lname edu--ht s: dob date1-date3;

Read more about variable lists at [1].