BookmarkSubscribeRSS Feed
SanjayM
Calcite | Level 5
How to left justify the title.

I am using PROC REPORT and ODS tagsets.excelxp
2 REPLIES 2
SriluP
Calcite | Level 5
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";
Cynthia_sas
SAS Super FREQ
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]

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 4394 views
  • 0 likes
  • 3 in conversation