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.
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.