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;
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
Thanks, Cynthia. I will do that and report back to this thread whatever the final resolution is.
This is a known bug. See http://support.sas.com/kb/46621
SAS was kind enough to provide code for a work-around.
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.