topic How to create a title page using tagsets.excelxp in SAS Programming

How to create a title page using tagsets.excelxp

zqkal — Tue, 12 Nov 2013 17:41:46 GMT

I’m creating a report that have multiple tab using tagsets.Excelxp. However, I want the first page to be title page and the title to be in the middle of the page.

Does anyone knows how I could create a title page using tageset.excelxp. or Have the title to be in the middle of the page while using tageset.excelxp.

Thanks

Re: How to create a title page using tagsets.excelxp

Tim_SAS — Tue, 12 Nov 2013 19:02:39 GMT

data;

drop i;

length line $100;

do i = 1 to 30;

if i = 15 then

line = 'This Is The Title Page';

else

line = ' ';

output;

end;

run;

ods listing close;

ods tagsets.excelxp file="test.xml";

proc report;

col line;

define line / '' style={background=white textalign=center fontsize=18pt fontweight=bold};

run;

ods tagsets.excelxp close;

Re: How to create a title page using tagsets.excelxp

zqkal — Tue, 12 Nov 2013 22:46:41 GMT

Thanks Tim