data have; infile datalines dsd; input id : 8. match1 : $8. match2 : $8. not_relevant : 8. ; datalines; 1,"ABC","ABC",4 1,"XYZ","XYZ",29 2,"QQQ","AAA",5 2,"ABC","ABC",9 3,"EFG","EFG",7 3,"DEF","DEF",12 3,"LMK","LMK",16 3,"KEF",,38 ; proc sql; create table want as select * from have where id not in (select id from have where match1 ne match2 and match1 is not missing and match2 is not missing); quit; ... View more

> If you are using earlier versions of SAS, you would have to include the above code in a macro. If you use an older version of SAS, here's another way that works in open code:   %sysfunc(ifc( &var3^=, %str( **proc sql code here** ) , %sysfunc(ifc( &var5^=, %str( **different proc sql code here** ) , )) ))       ... View more

There was a recent thread about some obscure poorly documented _dataout option in SAS/Studio.  I wonder if Enterprise Guide has some similar hidden trick for having your SAS code tell the caller (Enterprise Guide) what to do with the results? ... View more