Hello
I am currently using ODS and break statement to create report below
define fromlist/group 'List Type';
define rmailing_month/group 'Mailing Month' ;
define virtual_mth/group 'Virtual Month' noprint ;
define segment/display 'Segments';
define impression/analysis 'Impression';
break before rmailing_month / dol summarize suppress ;
List Type | Mailing Month | Segments | Impression |
14009 | |||
1- All Lists | 201401 | Overall | 14009 |
12992 | |||
201501 | Ballots all | 426 | |
Regular | 8339 | ||
Test1 | 2108 | ||
Test2 | 2119 | ||
14339 | |||
201402 | Overall | 14339 | |
14145 | |||
201502 | Ballots all | 389 | |
Regular | 9109 | ||
Test1 | 2322 | ||
Test2 | 2325 |
I want to make 2 changes as per my client request :
Changes:
(1) For data associated with months 201401, 201402, there is no breakdown on segment, there is always only 1 row (segment = overall ), So the summery row (bold) for 201401, 201402 is really redundant, my question is , how can i conditionally run Break statement so that for any months related to 2014, there will Not be any summary row.
(2) For the summary row, i actually want to display the value of mailing month as well (but keep it empty for listtype) how can i do that ?
Thanks
TC
1. Well then what if i dont use break statement, and use other statements, will i be able to display conditionally?
2. I just want to show bit more info on the summary row (see blue)
List Type | Mailing Month | Segments | Impression |
14009 | |||
1- All Lists | 201401 | Overall | 14009 |
201501 | Total | 12992 | |
201501 | Ballots all | 426 | |
Regular | 8339 | ||
Test1 | 2108 | ||
Test2 | 2119 | ||
14339 | |||
201402 | Overall | 14339 | |
201502 | Total | 14145 | |
201502 | Ballots all | 389 | |
Regular | 9109 | ||
Test1 | 2322 | ||
Test2 | 2325 |
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.