The SAS Output Delivery System and reporting techniques

TITLE_FOOTNOTE_NOBREAK works intermittently

Reply
Occasional Contributor
Posts: 8

TITLE_FOOTNOTE_NOBREAK works intermittently

 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?

SAS Super FREQ
Posts: 9,426

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

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
Occasional Contributor
Posts: 8

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

[ Edited ]
Posted in reply to Cynthia_sas

 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.

Occasional Contributor
Posts: 8

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

Ask a Question
Discussion stats
  • 3 replies
  • 121 views
  • 0 likes
  • 2 in conversation