Thank you for the try! Panelcols unfortunately did not work but sheet_interval='none' did have some effect.
When I did this...
Ods tagsets.ExcelXP style=XLsansPrinter options(sheet_name="&LCD." embedded_titles='yes' sheet_interval='none')
FILE = "&DIR.\XLS\20&CY. JH Auto Routine Edit Effectiveness Tracker A-L.xml";
...my output did all show up on one tab. This is good but I want a combination of varying tables going down a tab, but also producing multiple tabs. I can seem to get it to do one or the other, but not both. I tried iteratively switching between using the sheet interval and not using the sheet interval option but that did not work as I'd hoped...
ODS LISTING CLOSE;
%DO I = 1 %TO &ITERS;
%IF I = 1 %THEN %DO;
Ods tagsets.ExcelXP style=XLsansPrinter options(sheet_name="&LCD." embedded_titles='yes')
FILE = "&DIR.\XLS\20&CY. JH Auto Routine Edit Effectiveness Tracker A-L.xml";
PROC REPORT DATA= HA_T1 NOWD SPLIT="!";
WHERE LCD_DESCRIPTION = "&LCDDESC." AND X = &I;
COLUMN EDIT ACTIVE_DATE QTR CLAIMS_REVIEWED CLAIMS_DENIED PCT_CLAIMS_DENIED
CHARGES_REVIEWED CHARGES_DENIED PCT_CHARGES_DENIED
Avg_Dol_Saved_per_Claim_Reviewed;
TITLE1 "&LCD. - &LCDDESC.";
TITLE4 'PART A';
DEFINE EDIT / 'EDIT' style(column)={tagattr='format:@' just=c};
DEFINE ACTIVE_DATE / style(column)={tagattr='format:@' just=c};
DEFINE QTR / style(column)={tagattr='format:@' just=c};
DEFINE CLAIMS_REVIEWED / style(column)={tagattr='#,##0' just=c};
DEFINE CLAIMS_DENIED / style(column)={tagattr='#,##0' just=c};
DEFINE PCT_CLAIMS_DENIED / style(column)={tagattr='##0.0%' just=c};
DEFINE CHARGES_REVIEWED / style(column)={tagattr='$#,##0.00' just=c};
DEFINE CHARGES_DENIED / style(column)={tagattr='$#,##0.00' just=c};
DEFINE PCT_CHARGES_DENIED / style(column)={tagattr='##0.0%' just=c};
DEFINE Avg_Dol_Saved_per_Claim_Reviewed / style(column)={tagattr='$#,##0.00' just=c};
run;
%END;
%IF I > 1 %THEN %DO;
Ods tagsets.ExcelXP style=XLsansPrinter options(sheet_name="&LCD." embedded_titles='yes' sheet_interval='none')
FILE = "&DIR.\XLS\20&CY. JH Auto Routine Edit Effectiveness Tracker A-L.xml";
PROC REPORT DATA= HA_T1 NOWD SPLIT="!";
WHERE LCD_DESCRIPTION = "&LCDDESC." AND X = &I;
COLUMN EDIT ACTIVE_DATE QTR CLAIMS_REVIEWED CLAIMS_DENIED PCT_CLAIMS_DENIED
CHARGES_REVIEWED CHARGES_DENIED PCT_CHARGES_DENIED
Avg_Dol_Saved_per_Claim_Reviewed;
TITLE1 "&LCD. - &LCDDESC.";
TITLE4 'PART A';
DEFINE EDIT / 'EDIT' style(column)={tagattr='format:@' just=c};
DEFINE ACTIVE_DATE / style(column)={tagattr='format:@' just=c};
DEFINE QTR / style(column)={tagattr='format:@' just=c};
DEFINE CLAIMS_REVIEWED / style(column)={tagattr='#,##0' just=c};
DEFINE CLAIMS_DENIED / style(column)={tagattr='#,##0' just=c};
DEFINE PCT_CLAIMS_DENIED / style(column)={tagattr='##0.0%' just=c};
DEFINE CHARGES_REVIEWED / style(column)={tagattr='$#,##0.00' just=c};
DEFINE CHARGES_DENIED / style(column)={tagattr='$#,##0.00' just=c};
DEFINE PCT_CHARGES_DENIED / style(column)={tagattr='##0.0%' just=c};
DEFINE Avg_Dol_Saved_per_Claim_Reviewed / style(column)={tagattr='$#,##0.00' just=c};
run;
%END;
%END;
ODS tagsets.ExcelXP CLOSE;
ODS LISTING;
%mend BYLCD;
data _null_;
set /*ALLHLCDSAL*/ TEST;
BY LCD_DESCRIPTION;
call execute('%BYLCD('||LCD_DESCRIPTION||','||X||','||LCD||')');
run;
quit;
I'm hoping to get one tab per LCD, w/ multiple tables per tab. The above code gets me only one tab - continuously overwriting the LCD and leaving me with all the tables from the last LCD on that one tab.
... View more