07-30-2012 02:08 PM
I am trying to transfer SAS data to Excel using ODS tagset. The transfer works fine until I get to the footnotes. If I include only the first footnote the transfer still is correct. However when I add a second footnote, the text is truncated mid sentence. When I submit the code with no footnote or only the first footnote, the document opens in Excel without problem. When I submit the code including the second footnote, I get an Excel Problems During Load box. In the box it says "Problems came up in the following areas during load: Worksheet Setting".
If I click OK the document opens correctly, except for the footnote. I started having this problem after I down loaded the most resent tagset version. How can I get the footnote to display correctly? My code is included below.
TITLE "&RYR2 ADMISSION ADULTS STATUS REPORTS COMPLETED";
TITLE2 "&MONTHW1, &MONTHW2, AND &MONTHW3";
footnote height=1 JUSTIFY=LEFT "*The month a status report is due is determined by comparing the CIMOR admission date and the most recent status report entered into CIMOR in the past 12 months.";
footnote2 height=1 JUSTIFY=LEFT "If no previous status report was found in CIMOR in the past 12 months, the due month is the month of the CIMOR admission date.";
*The footnote truncated after "due month is the m'.
ods listing close;
ods tagsets.ExcelXP path='\\TSCLIENT\O\Rizner\TEST_SR'
ods tagsets.ExcelXP options(sheet_name='COMPLETED STATUS REPORTS'
PROC PRINT DATA=JUNK.ADULT&RMON1&RMON2&RMON3 NOOBS split='#';
SUM &MONTHW1.COMPLETED &MONTHW1.QUALADMITS &MONTHW3.COMPLETED
&MONTHW3.QUALADMITS &MONTHW2.COMPLETED &MONTHW2.QUALADMITS;
VAR &MONTHW1.COMPLETED &MONTHW1.QUALADMITS PERCENT_COMPLETED_&MONTHW1
/ style=[background=#F2B48C]; *TAN;
VAR &MONTHW2.COMPLETED &MONTHW2.QUALADMITS PERCENT_COMPLETED_&MONTHW2
/ style=[background=#F5DEB3]; *WHEAT;
VAR &MONTHW3.COMPLETED &MONTHW3.QUALADMITS PERCENT_COMPLETED_&MONTHW3
LABEL ORG='ORGANIZATION NAME'
&MONTHW1.QUALADMITS='NUMBER OF#QUALIFYING#ADMISSIONS#FOR ADULTS#In' &MONTHW1
&MONTHW2.QUALADMITS='NUMBER OF#QUALIFYING#ADMISSIONS#FOR ADULTS#In' &MONTHW2
&MONTHW3.QUALADMITS='NUMBER OF#QUALIFYING#ADMISSIONS#FOR ADULTS#In' &MONTHW3
&MONTHW1.COMPLETED='NUMBER OF#SR COMPLETED#FOR ADULTS#In' &MONTHW1
&MONTHW2.COMPLETED='NUMBER OF#SR COMPLETED#FOR ADULTS#In' &MONTHW2
&MONTHW3.COMPLETED='NUMBER OF#SR COMPLETED#FOR ADULTS#In' &MONTHW3
PERCENT_COMPLETED_&MONTHW1="PERCENT COMPLETED &MONTHW1"
PERCENT_COMPLETED_&MONTHW2="PERCENT COMPLETED &MONTHW2"
PERCENT_COMPLETED_&MONTHW3="PERCENT COMPLETED &MONTHW3";
ods tagsets.ExcelXP close;
07-30-2012 03:30 PM
If you are having problems like this, then your best bet is to open a track with Tech Support. If there are issues with the most recent update to TAGSETS.EXCELXP, then Tech Support can alert the developer about the problem.
To open a track with Tech Support, fill out the form at this link: http://support.sas.com/ctx/supportform/createForm