I just found this post, and invented a similar system for making data flow diagrams. I'd be interested to know if you found a solution to your problem of how the %include seemed to be excluded from Proc SCAPROC. You should try to contact Eric Thies (I thinkt that's his name) as he is the guy who made this PROC and could best comment on it. - Phil ... View more

Why are you using PROC SQL instead of normal data steps? If you just want one observation per ACCT_ID then it is probably easier to do with data step. data want ;   merge table1 (in=in1)             table2 (keep=acct_id field1 field2)             table3 (keep=acct_id field3) ....             tableN (keep=acct_id fieldZ) ; by acct_id ; if in1 and first.acct_id ; run; ... View more