Hi, I have a problem getting report grand totals to break out the way I want it. From what I have been reading, I need to create dummy breaks and dummy variables. It seems to me there should be an easier way but I don't know how. Has anyone ever done this? and how did you do it? I also can do a union in the dataset and just display but it seems proc report should be able to do this. I have the following data: Market_name Channel_Summary total_accts_m1 brkt brkb Greater Philadelphia Touchpoint 2 t b New England South Touchpoint 7 t b Western/Central Pennsylvania Touchpoint 1 t b _Incomplete Information Branch Intranet 1 t b _Incomplete Information Touchpoint 2 t b I want the output to look like this: Market Name Channel Accounts Greater Philadelphia Touchpoint 2 New England South Touchpoint 7 Western/Central Pennsylvania Touchpoint 1 _Incomplete Information Branch Intranet 1 Touchpoint 2 GRAND TOTAL TOUCHPOINT 12 GRAND TOTAL BRANCH INTRANET 1 and the following code: ods listing close; ODS tagsets.excelxp file = "\\wapprib00001040\Prod\output\excel\TESTRPT.xls" style = Barrettsblue options ( sheet_label = '' wraptext='yes' /*absolute_column_width='20'*/); /************************************************************** Output Market Trend ****************************************************************/ ods tagsets.excelxp options(sheet_name='Market Trend' ); proc report data = market_trend_tmp1 headskip split = '*' missing wrap ; column market_name channel_summary brkt brkb ("July 2014" total_accts_m1 total_accts_m1=nsal_m1); define market_name / group width=30 'Market Name' format=$30. style(column)={cellwidth=3.0in}; define channel_summary / group width=30 'Channel' format=$30. style(column)={cellwidth=3.0in}; define total_accts_m1 / analysis 'Accounts' center style(column)={cellwidth=0.9in } ; define nsal_m1 / n f=comma8. 'Count' ; define brkt / group noprint; define brkb / group noprint; break after brkt / summarize; break after brkb / summarize; rbreak after / summarize style(summary) = {font_weight=bold font_size=11pt } ; compute nsal_m1; if channel_summary = 'Touchpoint' then tcnt + nsal_m1; else if channel_summary = 'Branch Intranet' then bcnt + nsal_m1; endcomp; compute after brkt; total_accts_m1.sum = tcnt; channel_summary = 'Number of Touchpoint'; endcomp; compute after brkb; total_accts_m1.sum = bcnt; channel_summary = 'Number of Branch Intranet'; endcomp; compute after ; channel_summary = 'Total All'; endcomp; run ; ods tagsets.excelxp close; ods listing; I modified my code (the above) to try to do these dummy breaks and variables but it gives the below result which doesnt make sense. July 2014 Market Name Channel Accounts Count Greater Philadelphia Touchpoint 2 1 Greater Philadelphia Number of Branc 0 1 Greater Philadelphia Number of Touch 3 1 New England South Touchpoint 7 1 New England South Number of Branc 0 1 New England South Number of Touch 6 1 Western/Central Pennsylvania Touchpoint 1 1 Western/Central Pennsylvania Number of Branc 0 1 Western/Central Pennsylvania Number of Touch 9 1 _Incomplete Information Branch Intranet 1 1 _Incomplete Information Number of Branc 2 1 _Incomplete Information Number of Touch 9 1 Touchpoint 2 1 _Incomplete Information Number of Branc 3 1 _Incomplete Information Number of Touch 12 1 Total All 13 5 Can anyone help? Thanks in advance Laurie
... View more
