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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 4272 views
  • 0 likes
  • 3 in conversation