topic output file in pdf format with title in SAS Programming

output file in pdf format with title

ursula — Fri, 30 Jul 2021 22:33:38 GMT

Hi there,

I need help to output file in pdf format with a Title that correspondence to the ID.

I have 2 tables:

table 1:

ID	VISIT	LAB
10	1	YES
10	2	NO
10	3	NO
20	2	YES
20	3	YES
20	5	NO
20	6	NO

table 2:

ID	GENDER
10	FEMALE
20	MALE

I want the pdf output as following (page 1, page2 etc..)

PAGE 1 look like this:

GENDER: FEMALE

ID	VISIT	LAB
10	1	YES
10	2	NO
10	3	NO

PAGE2:

GENDER: MALE

ID	VISIT	LAB
20	2	YES
20	3	YES
20	5	NO
20	6	NO

How to code(link) the 2 tables into one output?

Thank you in advance, really appreciate your time.

Re: output file in pdf format with title

ChrisNZ — Sat, 31 Jul 2021 09:30:54 GMT

Like this?

data TABLE1;
input ID VISIT LAB $3.;
cards;
10 1 YES
10 2 NO 
10 3 NO 
20 2 YES
20 3 YES
20 5 NO 
20 6 NO 
run; 

data TABLE2;
input ID GENDER $6.;
cards;
10 FEMALE
20 MALE  
run;                                                      

proc sql;
  create table REPORT as select * from TABLE1, TABLE2 where TABLE1.ID=TABLE2.ID order by ID;
quit;
                                      
ods pdf file="&wdir\t.pdf" startpage=bygroup notoc;
proc print data=REPORT noobs; by GENDER; *title2 'GENDER:#byval1'; var ID VISIT LAB; run;
ods pdf close;

Re: output file in pdf format with title

ursula — Sun, 01 Aug 2021 02:17:31 GMT

Thank you so much for your help!

it's exactly of what I expected.