topic Re: ods pdf in SAS Data Management

ods pdf

J_hoon — Tue, 12 Mar 2019 07:47:41 GMT

Hi,

I have one question.

I using ods pdf for save my data set.

But, It has problem.

My data has many columns, so pdf file show two pages. Not one pages.

Then, I want to fix my first column for second page.

like this

pdf view

ID Age Weight Height ...... <- 1st page

1 15 157 58 ..........

BMI ..... <- 2nd page

<I want this pdf file>

ID Age Weight Height ...... <- 1st page

1 15 157 58 ..........

ID BMI ..... <- 2nd page

1 23

How do I solve this problem? please Help Me!

Re: ods pdf

Norman21 — Tue, 12 Mar 2019 08:19:46 GMT

You can do this with PROC REPORT. Cynthia has written a useful tutorial:

https://www.lexjansen.com/wuss/2010/TUT/3027_1_TUT-Zender.pdf

Re: ods pdf

RW9 — Tue, 12 Mar 2019 08:52:15 GMT

You can also adjust the orientation of the page:

options orientation=landscape;

Before your pdf call will set page to wider rather than longer so you can fit more or. You can also adjust cell widths:

proc report...
  ...
  define id / style={cellwidth=1cm};
...
run;

So the cell fits the data. You can add wrapping within cell with split characters, or adjust the font size, or put ID on a by line, or combine columns etc. There are hundreds of ways of achieving a certain output.

Re: ods pdf

andreas_lds — Tue, 12 Mar 2019 10:10:16 GMT

@J_hoon wrote:

Hi,

I have one question.

I using ods pdf for save my data set.

Why do you "save" your dataset as pdf? For re-using the data it would be better to copy the dataset to a permanent library.

Re: ods pdf

Ksharp — Tue, 12 Mar 2019 12:11:41 GMT

ods pdf file='c:\temp\x.pdf';
proc report data=sashelp.class nowd;
column name sex age weight height;
define name/display id;
define weight/display page;
run;
ods pdf close;