The SAS Output Delivery System and reporting techniques

ODS Tagsets.Excelxp problem using merge_titles_footnotes

Reply
Trusted Advisor
Posts: 1,496

ODS Tagsets.Excelxp problem using merge_titles_footnotes

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;

SAS Super FREQ
Posts: 8,719

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

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

Trusted Advisor
Posts: 1,496

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

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

Trusted Advisor
Posts: 1,496

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

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

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

N/A
Posts: 1

Re: ODS Tagsets.Excelxp problem using merge_titles_footnotes

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

Ask a Question
Discussion stats
  • 4 replies
  • 751 views
  • 0 likes
  • 3 in conversation