Thank you so much, that is beautiful! ... View more

Figured it out. I broke all of my joins into unique CREATE TABLEs. Not elegant, but it works and is fast.. ... View more

Here's one of the variations I've tried.  I've also tried a passthrough, as well as joining to my_sas_table instead of using an IN.  The sas table is just for testing, in the real program that will by dynamically built from a prompt.     LIBNAME mylib ORACLE PATH=mypath SCHEMA=myschema AUTHDOMAIN="mydomain" multi_datasrc_opt = IN_CLAUSE;   %global save_myvariable;   DATA my_sas_table; INPUT receipt_number $13; DATALINES; ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ABC1700150001 ; RUN;     PROC SQL;   CREATE TABLE work.temp2 as SELECT DISTINCT t1.FILE_CODE, t2.MAIN_FILE, t3.LAST_ACTION FROM mylib.FILE_TABLE t1 LEFT JOIN mylib.FILE_TABLE t2 ON t1.FILE_ID = t2.MAIN_FILE_ID LEFT JOIN mylib.FILE_DATES t3 ON t2.MAIN_FILE_ID=t3.FILE_ID AND t2.LAST_TRANSACTION_DATE=t3.TRANSACTION_DATE WHERE t1.FILE_CODE in (SELECT receipt_number FROM my_sas_table) ORDER BY t1.FILE_CODE; QUIT; PROC Print data=work.temp2; run; ... View more