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. CODE: %LET MON=JUNE12; %LET MONTHw1=APRIL; %LET MONTHw2=MAY; %LET MONTHw3=JUNE; %LET MONTHw1_3=APRIL_JUNE; %LET RMON1=4; %LET RMON2=5; %LET RMON3=6; %LET RYR='2012'; %LET RYR2=2012; 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; options topmargin=.5in bottommargin=.5in leftmargin=.25in rightmargin=.25in; ods tagsets.ExcelXP path='\\TSCLIENT\O\Rizner\TEST_SR' file="AdmASR_Completed&MONTHW1.&MONTHW2.&MONTHW3..XLS" STYLE=XLsansPrinter; ods tagsets.ExcelXP options(sheet_name='COMPLETED STATUS REPORTS' embedded_titles='yes' Orientation ='landscape' ROW_REPEAT='1-3' absolute_column_width='21,9,9,9,9,9,9,9,9,9'); *9,9,9,9,9,9,9,9'; PROC PRINT DATA=JUNK.ADULT&RMON1&RMON2&RMON3 NOOBS split='#'; SUM &MONTHW1.COMPLETED &MONTHW1.QUALADMITS &MONTHW3.COMPLETED &MONTHW3.QUALADMITS &MONTHW2.COMPLETED &MONTHW2.QUALADMITS; VAR ORG; 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 / style=[background=#FFFACD]; 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"; RUN; quit; ods tagsets.ExcelXP close; run; ods listing;
... View more
