topic Proc report Pages in SAS Programming

Proc report Pages

HitmonTran — Fri, 19 Oct 2018 18:49:43 GMT

Hi,

I was wondering if the below screen shot is possible to output "Part 1" & "Part 2" lab tests into one PDF output using proc report?

thanks

Re: Proc report Pages

Cynthia_sas — Fri, 19 Oct 2018 19:38:44 GMT

Hi:
It is pretty easy to do "page x of y" page numbers using ODS PDF. I guess the question is do you have the word "Parts" instead of "Page"??? Is a "part" the same as a "page"? If so, then something like this should work;

Output:

Code:

Cynthia

Re: Proc report Pages

Reeza — Fri, 19 Oct 2018 19:51:34 GMT

Look at the STARTPAGE option on the ODS PDF statement and set it to NONE or NEVER. Right not it likely defaults so each table is on it's own page.

Re: Proc report Pages

HitmonTran — Mon, 22 Oct 2018 22:17:53 GMT

Hi Cynthia,

No it's not pages/page # but rather separate variables from the same dataset:

col1-col7 = part 1

col1-col5, col8-col12 = part 2

Both need to be in the same pdf output but sort by "parts", thank you!

data all;
	merge fia hda mpa;
	by siteid trt01pn trt01p subjid avisitn adt  avisit; 

    		col1 = strip(siteid) ;
		col2 = strip(trt01p);
		col3 = 'S'||strip(subjid) ;
		col4 = strip(avisit)  ;
		col5 = strip(put(adt,date9.));
         
			/***PART 1***/
		***FIA;
		col6=strip(fiafia);
		col7= '' ; **missing "commens" column;


			/***PART 1***/
		***HDA;
		*format col9 col10 7.1;
		col8=strip(hda2);
		col9=strip(hda4); *HDA  Paralysis Time (min);
		col10=strip(hda3); *HDA Antibody Titer (IU/L);

		***MPA;
		*format col12 7.1;
		col11=strip(mpa5);
		col12=strip(mpa6); *mortality;
run;

Re: Proc report Pages

HitmonTran — Tue, 23 Oct 2018 17:25:57 GMT

was able to solve this by using the same filename=