The SAS Output Delivery System and reporting techniques

Help on SAS ODS

Reply
Occasional Contributor
Posts: 19

Help on SAS ODS


Hi All,

It would be really great , if you could help me on the below scenario. I have dataset which has 13 column and it needs to be converted as pdf or rtf file format so i have used ODSbut the problem is I am not getting all the columns in the single layer. my output format is 5 columns in first layer, 4 columns in second layer and 4 columns in third layer,

In order to meet aesthetics i want all the columns should be in single layer itself. Please see the example below.

Emp_No   Emp_Name   Department   DOB   DOJ   Base_Branch   Salary   DOP   Experience   Base_Branch   Deputed_Branch   Birth_Place   Nationality

Many Thanks.

Super User
Super User
Posts: 7,993

Re: Help on SAS ODS

Posted in reply to KannanBaskar

Well, the page size is only so big.  You can do a few things to shrink sizes:

ods pdf file="c:\abc.pdf";

proc report data=have nowd split="~";

     columns a b c d;

     define a / "A~B" style(colum)={cellwidth=2cm font_size=8pt};

...

So in the above, I shrink the layout by doing these things:

the Label A B, I split this over two lines with the split char ~.  I also fix the column width, this will of course cause wrapping in the cell, but if you want to squish it on one page, then there has to be concessions).  And also I shrink the font size.

Super User
Posts: 10,044

Re: Help on SAS ODS

Posted in reply to KannanBaskar

options orientation=landscape pagesize=max ;

SAS Super FREQ
Posts: 8,868

Re: Help on SAS ODS

Hi:

  Yes ORIENTATION= LANDSCAPE will work to increase the available horizontal area. And, you can use the margin options to decrease the normal margins. But ODS PDF does not use PAGESIZE option settings. If you look at the documentation on PAGESIZE, you will see that it is mostly a LISTING option

SAS(R) 9.4 System Options: Reference, Fourth Edition

  And since ODS PDF is making a page size based on a bunch of other settings, the "max" of 32767 "lines" doesn't make sense, since PDF uses settings like ORIENTATION, PAPERSIZE, MARGINS (for options) and font size, cellwidth and cellpadding for the report cells, using PAGESIZE=MAX isn't the best choice for ODS PDF.

cynthia

Super User
Posts: 10,044

Re: Help on SAS ODS

Posted in reply to Cynthia_sas

Sorry. It is papersize= , I mixed up with pagesize=.

options papersize=(10in 40in);


Papersize= can enable you to define as wide paper as you want .

Which means you can hold all these variables in a row .




Xia Keshan

Ask a Question
Discussion stats
  • 4 replies
  • 498 views
  • 0 likes
  • 4 in conversation