Showing posts with label report. Show all posts
Showing posts with label report. Show all posts

Thursday, June 3, 2010

How to identify the header of ACROSS columns in PROC Report

When one across item is used with >1 analysis items, the header text of the across item will affect all. To use different header text, we have to specify an alias for the across item.
Below are the sample codes:

* Default;
proc report data=sashelp.class nowd;
column sex,height sex,weight;
define sex / across;
define height / analysis mean;
define weight / analysis mean;
run;

* To use alias for the across item;
proc report data=sashelp.class nowd;
column sex,height (sex=sex_alias),weight;
define sex / across "Height";
define sex_alias / across "Weight";
define height / analysis mean " ";
define weight / analysis mean " ";
run;

Tuesday, August 18, 2009

Are you missing "missing option"?

Generally, SAS do not take missing value as a valid value, especially for class variable. That means there will be an implicit filter to delete all "missing" class, e.g. the class variable in Proc MEANS, PROC FREQ.

Likewise, missing values is not valid value for any group, order or across variable in Proc REPORT.

Wednesday, November 26, 2008

PROC Report manual issue

We can get two different introduction for PROC Report execution.
One is from SAS manual while the other from Carpenter’s Complete Guide to the SAS® REPORT Procedure.

Actually, I perfer the latter.
SAS manual give out confusing infor. And it is not reader-friendly.