Can we add some text in between two proc reports and print in one page ? id fname lname age 1 fname1 lname1 25 2 fname2 lname2 26 3 fname3 lname3 27                 Text in between "Table B display something like that "                         key calc     99 105 cal     86 264 cal     87 275 text     ... View more

data test; input id fname $4. lname $5. age; cards; 123 abc1 def1 24 124 abc2 def2 25 125 abc3 def3 26 ; run; in proc report how to get output below based upon condition ?   if id = 123 then display only fname and lname   fname lname abc1 def1 abc2 def2 abc3 def3 if id = 124 then display only fname fname abc1 abc2 abc3 if id = 125 then display only age age 24 25 26 ... View more

data test; input id fname $4. lname $5. age; cards; 123 abc1 def1 24 124 abc2 def2 25 125 abc3 def3 26 ; run; data test2; input id state $7. county $9. ; cards; 123 state1 county1 124 state2 county2 125 state3 county3 ; run;   options orientation=landscape; ods pdf file="location\name.pdf"; Title1 "Test"; ods proclabel=''; proc report data=test contents='' headline nowindows ;by id ; columns id fname lname age; run; proc report data=test2 contents='' headline nowindows ;by id ; columns id state county; run; ods pdf close;     Iam looking only one table of contnets for both tables on left side ? is there any i can do and get the ouput ?     ... View more

Hi , When i use macro variables inside the sql i can see the values in log if i use symbol gen  Isn't there a way to see it in the SQL? like expected output below ?   input :   %let test=abc; %let test2=xyz;   data ds; x=1; y=2; run; options symbolgen; proc sql; create table &test._&test2. as select * from ds; quit;     Log;     40         options symbolgen; 41         proc sql; 42         create table &test._&test2. as SYMBOLGEN:  Macro variable TEST resolves to abc SYMBOLGEN:  Macro variable TEST2 resolves to xyz 43         select * 44         from ds;     Expected output :   Isn't there a way to see it in the SQL?    proc sql create table abc_xyz as seelct * from ds; quit;     ... View more