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
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;
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;
Thanks Tim
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.