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 |
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.