topic Re: PROC PRINT and titles in SAS Programming

PROC PRINT and titles

sams54156 — Wed, 26 Sep 2018 14:37:58 GMT

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 .

Re: PROC PRINT and titles

Reeza — Wed, 26 Sep 2018 14:50:50 GMT

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&docsetVersion=9.4&locale=en

@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 .

Re: PROC PRINT and titles

sams54156 — Wed, 26 Sep 2018 15:45:05 GMT

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

Re: PROC PRINT and titles

Reeza — Wed, 26 Sep 2018 15:49:02 GMT

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

Re: PROC PRINT and titles

ballardw — Wed, 26 Sep 2018 22:38:14 GMT

@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.