BookmarkSubscribeRSS Feed
Tina1202
Fluorite | Level 6

 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?

3 REPLIES 3
Cynthia_sas
SAS Super FREQ
Hi: Without values for the macro variables and some generic steps, nobody can run this without making up macro variables and making up a few PROC PRINTS.

Tech Support is more geared to something like this where they can look at ALL your code and your data and help you figure out whether it's an issue with ODS EXCEL or with your options.

Cynthia
Tina1202
Fluorite | Level 6

 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.

Tina1202
Fluorite | Level 6

Here are the other 5 input files.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1268 views
  • 0 likes
  • 2 in conversation