Proc Report Summarize specific columns instead of all in break row

rm17tink — Fri, 15 May 2015 18:21:33 GMT

I need to summarize specific columns after my 'break after' the reason being I dont need my percentage columns summed up in that break row. it looks quit ugly. Also I want to name my Break After Rows with a different title. Any help

6 coulmns of data grouped by X

Break After X to Sum only columns of values not percentages

Thanks.

Re: Proc Report Summarize specific columns instead of all in break row

Cynthia_sas — Fri, 15 May 2015 18:52:21 GMT

Hi: Without seeing your data or the program you've tried, it is hard to make a constructive suggestion. However, usually if you want to prevent the automatic summary of a column, you define it as a DISPLAY (or ORDER or GROUP) usage. Consider this program where AGE is summarized (because default usage is ANALYSIS SUM) but HEIGHT and WEIGHT are NOT summarized because of the usage of display.

Cynthia

proc report data=sashelp.class;

where age in (12, 13, 14);

title 'Turn off Summarize for HEIGHT and WEIGHT';

column sex name age height weight;

define sex / order 'Gender';

define name / display;

define age / 'Age';

define height / display;

define weight / display;

break after sex / summarize;

rbreak after / summarize;

run;

The results:

topic Re: Proc Report Summarize specific columns instead of all in break row in SAS Programming

Proc Report Summarize specific columns instead of all in break row

Re: Proc Report Summarize specific columns instead of all in break row