BookmarkSubscribeRSS Feed
sams54156
Calcite | Level 5

Hi All ,

I have couple of questions regarding PROC PRINT .

1. How can I align title from column 1 . It always comes in the center .

2. how can I increase the font only for Title

3. I have 7 variables which come in column in proc print . How can I make it tabular . so that it will be easy to upload the output to a xl file .

 

Please suggest .  

4 REPLIES 4
Reeza
Super User

Have you tried applying any options? 

 

Justify/J for alignment

HEIGHT for size

 

I don't understand your third question. But if you're trying to get an XLSX file, just use ODS EXCEL.

 

ods excel file="myfile.xlsx" style=seaside;

title j=l height=20 "This is a demo";

proc print data=sashelp.class;
run;

ods excel close;

https://documentation.sas.com/?docsetId=grstatproc&docsetTarget=n1ukd9sqgqiwwhn1mrx4c1rbse1j.htm&doc...

 


@sams54156 wrote:

Hi All ,

I have couple of questions regarding PROC PRINT .

1. How can I align title from column 1 . It always comes in the center .

2. how can I increase the font only for Title

3. I have 7 variables which come in column in proc print . How can I make it tabular . so that it will be easy to upload the output to a xl file .

 

Please suggest .  



sams54156
Calcite | Level 5

thanks for the reply .

I used this ,

proc print data=BASEFILE noobs;                         
TITLE1 "TOTAL NO OF EXCEPTION : &nobs" height=50 JUSTIFY=L;
options nodate;

 

This didn't increase the font neither did it align the title to left .

 

TOTAL NO OF EXCEPTION

 

 

Reeza
Super User
Does mine work? If so, what’s the difference between my code and yours?
ballardw
Super User

@sams54156 wrote:

thanks for the reply .

I used this ,

proc print data=BASEFILE noobs;                         
TITLE1 "TOTAL NO OF EXCEPTION : &nobs" height=50 JUSTIFY=L;
options nodate;

 

This didn't increase the font neither did it align the title to left .

 

TOTAL NO OF EXCEPTION

 

 


The modifiers come before the text that you want to modify. Since you placed all of the modifiers after all the text there was nothing to modify.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 4 replies
  • 3227 views
  • 0 likes
  • 3 in conversation