topic Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes in ODS and Base Reporting

ODS Tagsets.Excelxp problem using merge_titles_footnotes

PaigeMiller — Mon, 06 May 2013 14:59:52 GMT

SAS 9.3 TS1M2, Windows 7 Pro 64 bit

Tagsets.Excelxp version v1.130

I want to create an Excel spreadsheet with two tabs. I have that working properly using ODS Tagsets.Excelxp and PROC REPORT, except for one little thing ...

I want different titles on each tab, and I want the titles in a single merged cell at the top of each worksheet. I have no problem getting different titles on each worksheet, however, the merging never works properly on the 2nd tab. It always (as far as I can tell) uses the number of columns in tab 1. For example, tab 1 has 7 columns and tab 2 has 10 columns defined, and on tab 2, no matter what I do, the title is merged across 7 columns, not 10. Yes, there are 10 columns from PROC REPORT being output to Tab2. Is this a bug, or a user error?

Outline of code:

ods tagsets.excelxp file="myfilename.xml" options(sheet_name="Tab1" embedded_titles='Yes' Absolute_Column_Width='(4,12,10,10,10,10,10)' merge_titles_footnotes='Yes');

title 'Some Title';

proc report data=...

run;

ods tagsets.excelxp options(sheet_name="Tab2" embedded_titles='Yes' Absolute_Column_Width='(4,12,10,10,10,10,10,10,10,10)' merge_titles_footnotes='Yes');

title 'Some Different Title';

proc report data=...

run;

ods tagsets.excelxp close;

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

Cynthia_sas — Mon, 06 May 2013 19:35:06 GMT

Hi:

I see the behavior you describe, but I don't know whether there is a workaround for it or not. The only folks who might know would be Tech Support. I'd suggest you open a track with Tech Support on this question. If this is something that needs to be fixed in the tagset template for the destination, then Tech Support can open a defect and alert the developers.

cynthia

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

PaigeMiller — Mon, 06 May 2013 19:49:31 GMT

Thanks, Cynthia. I will do that and report back to this thread whatever the final resolution is.

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

PaigeMiller — Tue, 07 May 2013 13:44:51 GMT

This is a known bug. See http://support.sas.com/kb/46621

SAS was kind enough to provide code for a work-around.

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

tanyach — Wed, 24 Jul 2013 16:32:18 GMT

Would you share the work-around? We have the same issue with SAS 9.3 tagsets that came with installation. We did not see the same issue in SAS9.2