topic Re: Problem having required pdf output. in SAS Programming

Problem having required pdf output.

bonzybuddy — Mon, 13 May 2013 14:50:39 GMT

Hi there,

I am creating a pdf output file using PROC REPORT. in my code I am having two columns as ID which is going to be repeated on all the pages.

in my output, I am having 8 columns which can not fit into one horizontal page layout. So what I am doing is, I am keeping

4 columns on first page and rest 4 on second page using 'page' statement.

My problem is, I am having around 500 observations sometimes. So in PDF what happenes is, in first few pages all first 4 columns are

finished first and then pages for rest of the column starts.

For example, I have 500 obs and 8 columns. Then first 10 pages shows first 4 columns for all the obs and then rest 5-8 columns are printed

in next 10 pages. But my requirement is to print first page page with 1-4 columns followed by page showing 5-8 columns.

I hope I have simplified enough the problem to understand better. Quick help is appreciated.

Thanks.

Message was edited by: bonzy buddy

Re: Problem having required pdf output.

ballardw — Mon, 13 May 2013 14:55:41 GMT

How are you generating the ouput? Proc Print, Report, Tabulate or something else? Different methods have different options.

Re: Problem having required pdf output.

bonzybuddy — Mon, 13 May 2013 14:59:56 GMT

Proc report

Re: Problem having required pdf output.

bonzybuddy — Mon, 13 May 2013 16:25:13 GMT

NO one!!!!

Re: Problem having required pdf output.

Tom — Mon, 13 May 2013 17:06:22 GMT

I do not know of a good way. You could try breaking the data into groups and using the group variable as a BY variable. But predicting where would be a good place to split that would yield nice looking tables could be hard. Here is an example using SASHELP.CARS.

ods pdf ;

ods listing close;

options nobyline ;

data cars;

page=int( (_n_-1) / 25) ;

set sashelp.cars (obs=50);

run;

proc report data=cars nofs missing;

by page;

define page / noprint ;

define model / id ;

define mpg_city / page ;

run;

options byline;

ods listing ;

ods pdf close;