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

Reply
N/A
Posts: 1

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

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;

SAS Super FREQ
Posts: 8,742

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

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

Ask a Question
Discussion stats
  • 1 reply
  • 165 views
  • 0 likes
  • 2 in conversation