topic Re: Proc Report in New SAS User

Proc Report

DLROW — Fri, 19 Apr 2019 17:20:11 GMT

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.

Re: Proc Report

VDD — Fri, 19 Apr 2019 17:32:26 GMT

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;

Re: Proc Report

DLROW — Fri, 19 Apr 2019 17:35:48 GMT

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.

Re: Proc Report

PaigeMiller — Fri, 19 Apr 2019 17:40:57 GMT

See if this helps

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

Re: Proc Report

DLROW — Fri, 19 Apr 2019 18:20:00 GMT

Thank you, It works.