Proc Report Summarize specific columns instead of all in break row

Reply
N/A
Posts: 1

Proc Report Summarize specific columns instead of all in break row

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.

SAS Super FREQ
Posts: 8,716

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

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:

turn_off_summarize.png

Ask a Question
Discussion stats
  • 1 reply
  • 212 views
  • 0 likes
  • 2 in conversation