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;
Hi:
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
cynthia
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.