Proc Report

[DLROW]

Hi , 

Please see below,

Proc sort data=sashelp.class out=cl1;
by age;
run;
data class;
set cl1;
by age;
if first.age then cnt+1;
run;
Proc report data=class nowd;
column cnt age sex, height;
define cnt / group;
define age / group;
define sex / across;
define height/analysis mean;
run;

When the above code is run I get the column names as

                                   sex

                        F                      M

Cnt  Age         Height              Height

I want the columns to be displayed as Cnt, Age, F, M . Please let me know how to  remove sex and Height from the layout.

Thanks.

[VDD]

remove height from you column statement

Proc sort data=sashelp.class out=cl1;
by age;
run;
data class;
set cl1;
by age;
if first.age then cnt+1;
run;
Proc report data=class nowd;
column cnt age sex;*, height;
define cnt / group;
define age / group;
define sex / across;
define height/analysis mean;
run;

[DLROW]

It doesn't work. If I remove height from the column statement then Mean of Height  is not displayed under the column M and F. Only the observation count is displayed. Thanks.

[PaigeMiller · Accepted solution]

See if this helps

https://communities.sas.com/t5/ODS-and-Base-Reporting/Remove-blank-header-in-PROC-REPORT/m-p/525553#...

[DLROW]

Thank you, It works.