topic Re: TITLE_FOOTNOTE_NOBREAK works intermittently in ODS and Base Reporting

TITLE_FOOTNOTE_NOBREAK works intermittently

Tina1202 — Tue, 19 Jun 2018 17:25:52 GMT

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?

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

Cynthia_sas — Tue, 19 Jun 2018 21:55:23 GMT

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

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

Tina1202 — Thu, 21 Jun 2018 15:08:12 GMT

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.

Re: TITLE_FOOTNOTE_NOBREAK works intermittently

Tina1202 — Thu, 21 Jun 2018 15:06:52 GMT

Here are the other 5 input files.