Using footnotes in transfer of SAS data to Excel using ODS tagset.

judyr — Mon, 30 Jul 2012 18:08:05 GMT

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;

Re: Using footnotes in transfer of SAS data to Excel using ODS tagset.

Cynthia_sas — Mon, 30 Jul 2012 19:30:48 GMT

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

topic Re: Using footnotes in transfer of SAS data to Excel using ODS tagset. in SAS Programming

Using footnotes in transfer of SAS data to Excel using ODS tagset.

Re: Using footnotes in transfer of SAS data to Excel using ODS tagset.