DATA Step, Macro, Functions and more

How to create a title page using tagsets.excelxp

Accepted Solution Solved
Reply
Contributor
Posts: 43
Accepted Solution

How to create a title page using tagsets.excelxp

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


Accepted Solutions
Solution
‎11-12-2013 02:02 PM
Super Contributor
Posts: 394

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

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;

View solution in original post


All Replies
Solution
‎11-12-2013 02:02 PM
Super Contributor
Posts: 394

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

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;

Contributor
Posts: 43

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

Thanks Tim

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 171 views
  • 0 likes
  • 2 in conversation