I am using ODS EXCEL to create two tabs on a single Excel file. I have the exact same options for both tabs, but on the first one, the TITLE_FOOTNOTE_NOBREAK doesn't seem to work. That is, my Title statements are wrapping and can only be revealed in total when I go into the Excel file and click Wrap Text to disable it. Here is the code I'm using for the Options:
ODS EXCEL FILE = "TITLE_FOOTNOTE_NOBREAK sample.xlsx"
OPTIONS
(EMBEDDED_TITLES='YES'
EMBED_TITLES_ONCE= 'YES'
EMBEDDED_FOOTNOTES = 'YES'
START_AT='A1'
GRIDLINES='ON'
TITLE_FOOTNOTE_NOBREAK='YES'
SHEET_NAME = 'DED'
SHEET_INTERVAL='NONE'
ABSOLUTE_COLUMN_WIDTH = '15,50,15,15,15,25,10,15.2,15.2,15'
);
TITLE J=L 'Customer Segment Number: ' &FIRST_POLICY_GALAXY.;
TITLE2 J=L 'Customer Name: ' &CUST_NAME.;
TITLE3 J=L 'Service Date: ' &FIRSTSERV. ' - ' &LASTSERV.;
TITLE4 J=L 'Process Date: ' &FIRSTSERV. ' - ' &LASTPROC.;
TITLE5 J=L ' ';
This is the one where the Titles wrap.
Here is the Options statement for the second tab:
ODS EXCEL OPTIONS
(EMBEDDED_TITLES='YES'
EMBED_TITLES_ONCE= 'YES'
EMBEDDED_FOOTNOTES = 'YES'
START_AT='A1'
GRIDLINES='ON'
TITLE_FOOTNOTE_NOBREAK='YES'
SHEET_NAME = 'OOP'
SHEET_INTERVAL='NONE'
ABSOLUTE_COLUMN_WIDTH = '15,50,15,15,15,25,10,15.2,15.2,15'
);
TITLE J=L 'Customer Segment Number: ' &FIRST_POLICY_GALAXY.;
TITLE2 J=L 'Customer Name: ' &CUST_NAME.;
TITLE3 J=L 'Service Date: ' &FIRSTSERV. ' - ' &LASTSERV.;
TITLE4 J=L 'Process Date: ' &FIRSTSERV. ' - ' &LASTPROC.;
TITLE5 J=L ' ';
I've attached the Excel file without any data.
Any suggestions?
Attached is my ODS code, output Excel file, and 3 of my input files. I'll send the other 5 input files in a separate post. The output Excel file shows the issue on the DED tab. Note the Wrap Text and Merge and Center formats are highlighted on both tabs, but they only seem to be active on the DED tab.
Here are the other 5 input files.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.