topic Re: proc report with ODS layout in SAS Programming

proc report with ODS layout

draroda — Fri, 17 Feb 2017 14:57:45 GMT

Hi All,

I am creating patient profile data where i need to place all data for one subject on same page but due to number of rows and number of columns in dataset i am not able to accomodate on same page.

I need to place data from first two dataset on first page and data from another two dataset on second page and data from last datasets on third page.

Can you please guide how can we do this ?

Regards,

Rajesh

Re: proc report with ODS layout

nehalsanghvi — Fri, 17 Feb 2017 15:10:14 GMT

Can you provide a sample of your data and the code you have tried so far? Fitting data on to pages is generally an exercise in adjusting font size, column label, data formatting, column widths, co-ordinates of regions, etc.

Re: proc report with ODS layout

ballardw — Fri, 17 Feb 2017 15:43:06 GMT

What ODS destination are you using?

And does this have to fit on actual paper or a logic page in a document? If not intended for print you can set options Papersize to a height and width that could work.

Though you my be chasing a goal that is difficult to obtain due to the nature of your data. As soon as you solve this for a patient with 100 rows of data you'll get a new one with 200 rows.

This mixing of data sets is a headache in that you either are going to get into macro coding to loop over patients and then do the output for each patient or a radical restructure of data.

Here is some pseudo code as an example of a macro approach:

%macro mix;

proc sql;

select distinct PatientID into : Patients separated by " "

from yourdatasetwithpatientids;

quit;

%let PatCount=&sqlobs; /* this will have the number of unique patient ids*/

%do i = 1 %to &Patcount;

%let pat = %scan(&patients,&i); /* patient id for this report*/

%end;

%mend;