The SAS Output Delivery System and reporting techniques

How to left justify title

Reply
Frequent Contributor
Posts: 97

How to left justify title

How to left justify the title.

I am using PROC REPORT and ODS tagsets.excelxp
N/A
Posts: 1

Re: How to left justify title

Use the option embedded_titles='yes' in the ODS Tagset statement and in the title statment type j=l; see the example code below.

ods tagsets.excelxp options(embedded_titles='yes' );

title j=l "Left justify the title";
SAS Super FREQ
Posts: 8,868

Re: How to left justify title

Hi:
Are you using any of the suboptions that normally impact the title??? Also, it depends on whether you mean the SAS title, which comes from a TITLE statement or an Excel header for printing, which comes from the PRINT_HEADER suboption.

You will have to look at the output in Print Preview mode to see the impact of the PRINT_HEADER suboption. the &L is the instruction for left-justifying the print header and the &R is the instruction for right-justifying the print header. You can read more about these and other options in the SAS log.

cynthia
[pre]
ods tagsets.excelxp file='c:\temp\just_title.xls' style=sasweb
options(doc='Help' embedded_titles='yes' print_header='&L String Left &R String Right' );

title 'SAS Title Centered on Table';
proc report data=sashelp.class(obs=3) nowd;
run;

title 'SAS Title Centered on Table';
proc report data=sashelp.class(obs=3) nowd;
run;

ods _all_ close;
[/pre]
Ask a Question
Discussion stats
  • 2 replies
  • 1166 views
  • 0 likes
  • 3 in conversation