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.
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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.