I'm trying to accomplish this using the Enterprise Guide GUI, and it generates SQL code. I'll need to modify the code.   So I'm guessing that there is not a way to specify the IN option in Enterprise Guide, besides modifying the SQL code...   Thanks for the help!! ... View more

There's alot on the web on the use of IN in SAS file merging. See two examples here:   https://documentation.sas.com/?docsetId=lestmtsref&docsetTarget=n1i8w2bwu1fn5kn1gpxj18xttbb0.htm&docsetVersion=9.4&locale=en#n01jepaobjvwmyn1kd3bghrqo707   Regardless, I'm matching two datasets and want to separate the results into those records that have a match in data1 (master) from those without a match. So I join and use the indicators of indata1=1 and indata2=1 VS indata1=1 and indata2=0 VS indata1=0 and indata2=1.   Thank you for your assistance! ... View more

Sure! In SAS Studio, it would be  Data merged;   merge data1 (in=indata1) data2 (in=indata2);   by id;run;   EG generates PROC SQL code that errors out (below)- PROC SQL NOEXEC; SELECT t1.TRI2, t1.TOTAL_PAID_AMT,  t1.TOTAL_BILLED_AMT,  t1.CLAIM_TYPE, t2.REC_IND,  t2.AMT_PAID,  t2.AMT_BILLED  FROM WORK.QUERY_FOR_SORTSORTED_0001(in=inmaster) t1 12 INNER JOIN WORK.QUERY_FOR_SORTSORTED_0002(in=inmrr) t2 ON (t1.TRI2 = t2.TRI2);   ERROR: Invalid option name IN. ERROR: Some options for file WORK.QUERY_FOR_SORTSORTED_0001 were not processed because of errors or warnings noted above. ERROR: Invalid option name IN. ERROR: Some options for file WORK.QUERY_FOR_SORTSORTED_0002 were not processed because of errors or warnings noted above. 13 QUIT;   ... View more