Thanks. That code does achieve the single row between groups. Sadly, It does lose the other features which I need, such as the index and the embedded titles. I could only get this exact code to work ( and I really dont understands why it does work ). Any other modification cause the doubling of rows. It is interesting. I will call this as a solution, since it's good enough. ... View more

Actually - full code is posted above. Here is a screen print of what my output looks like in Excel: NOTE - I placed 'why' text in the Line statement to help differentiate between the 2 lines. One line is totally blank and the other has a border around it. Thanks again. ... View more

thanks again. Did not solve the problem for me. Does this work on your system? Maybe the problem has something to do with Excel 2007. ... View more

Thanks, but that creates a worksheet for each subgroup. Here is full code that replicates the issue using SAShelp.shoes. Options missing=0; ODS Listing close; ods tagsets.ExcelXP file="M:\_a_Test_Grp.xml"    style=SEASIDE options(embedded_titles='yes' embedded_footnotes='yes'            index = 'yes'            /*doc='Help' */        ); ods tagsets.excelxp options(sheet_name="By region") ; title4 'By region'; proc report data= sashelp.shoes             nowd  split='*'                 style(report)=       [FONT_FACE='Calibri'  cellspacing=0 rules=groups                       borderwidth=1 bordercolor=blue] STYLE(Header)=       [FONT_FACE='Calibri'  fontweight=bold] STYLE(Summary)=      [FONT_FACE='Calibri'  fontweight=bold]   ; column region sales         ; define region         / group; define sales          / analysis sum  Format=comma9.         style=[tagattr="format:#,##0"]; rBreak after         /  summarize ;   Break AFTER region  /  summarize ; Compute after region /          style={foreground=white background=white                 cellheight=1px font_size=1px};         line ''; endComp; Compute after ;         region = 'Grand Total'; endComp; run; ods tagsets.ExcelXP close; ods listing; Removing the Compute block for the blank line gives no rows between groups. ... View more