You could check out the following link, which references a section in the SAS documentation that covers combining SAS datasets. It's powerful, but not like any other language out there (quite different from SQL). Tom http://support.sas.com/documentation/cdl/en/lrcon/65287/HTML/default/viewer.htm#p15jvywi5avt3cn1bee8r6c33ux1.htm
... View more