topic Re: ODS excel Title appears only once in ODS and Base Reporting

ODS excel Title appears only once

JHE — Thu, 03 May 2018 17:16:04 GMT

I have SAS code:

ODS LISTING CLOSE;

ods excel file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/LTSS/TEST_HDM.xlsx"

style=Print;

ods excel options(

sheet_name =' HDM_PROVIDERS'

embedded_titles='yes'

EMBEDDED_FOOTNOTES= 'Yes'

sheet_interval="none"

orientation='landscape');

Title 'HDM Provider Monthly Report'

RUN;

%MACRO vLOB(vName1);

PROC PRINT DATA=HDM_PROVIDER_&vName1.TRANS NOOBS;

RUN;

%mend vLOB;

%vLOB(0100);

%vLOB(5400);

%vLOB(5410);

%vLOB(7100);

%vLOB(7200);

ODS _ALL_ CLOSE;

I need title only appears once not multiple times.

Re: ODS excel Title appears only once

Cynthia_sas — Thu, 03 May 2018 18:18:01 GMT

Hi:
I believe there is an option to only embed titles once. You may need to refer to the documentation to verify.
Cynthia

Re: ODS excel Title appears only once

JHE — Thu, 03 May 2018 18:24:29 GMT

Oh, I see, Should be related with ods title option ?

Re: ODS excel Title appears only once

Cynthia_sas — Thu, 03 May 2018 18:58:20 GMT

Hi,
It is a sub-option just like embedded_titles or sheet_interval or sheet_name. If you look here
http://go.documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en
and search, you should see: EMBED_TITLES_ONCE='on' as a sub-option and you specify it just like you did the other sub-options in your code:
ods excel file=". . ./TEST_HDM.xlsx"
          style=Print
          options(sheet_name =' HDM_PROVIDERS'
                    embedded_titles='yes'
                    embed_titles_once='on'
                    EMBEDDED_FOOTNOTES= 'Yes'
                    sheet_interval="none"
                    orientation='landscape');

There are also separate options for print headers and footers that are visible when the sheet is printed.

Cynthia

Re: ODS excel Title appears only once

Quentin — Thu, 03 May 2018 19:04:07 GMT

Couldn't you just turn it off? e.g.:

title1 'HDM Provider Monthly Report' ;
%vLOB(0100)
title1; *Clear title;

%vLOB(5400)
%vLOB(5410)
%vLOB(7100)
%vLOB(7200)

Re: ODS excel Title appears only once

JHE — Thu, 03 May 2018 19:49:11 GMT

Dose not work even added option.

ODS LISTING CLOSE;

ods excel file="/mnt/nfs/prod/Sched/OpsDeptData/Operations/Reports/LTSS/TEST_HDM.xlsx"

style=Print;

ods excel options(

sheet_name =' HDM_PROVIDERS'

embedded_titles='YES'

embed_titles_once='ON'

sheet_interval="none"

orientation='landscape'

);

RUN;

title 'TEST';

%MACRO vLOB(vName1);

PROC PRINT DATA=HDM_PROVIDER_&vName1.TRANS NOOBS;

RUN;

%mend vLOB;

%vLOB(0100);

%vLOB(5400);

%vLOB(5410);

%vLOB(7100);

%vLOB(7200);

ODS _ALL_ CLOSE;

Re: ODS excel Title appears only once

JHE — Thu, 03 May 2018 19:52:51 GMT

thanks, this one works.