Match 2 out of 3 conditions?

[Tom]

Post the code.  Or Post the lines from the SAS log. Make sure to use the Insert Code or Insert SAS Code button.

Your original code was only referencing one dataset named A but assigning the alias B to it because you wrote

from A B
where ...

To see that type of mistake in action try this code:

data a b; 
  set sashelp.class; 
  if sex='M' then output a ;
  else output b;
run;

proc sql ;
select a.*,b.*
from a b
;
quit;

Instead use

from A , B
where ...

or

from A 
inner join B
on ....

[ChrisNZ]

>  Could someone let me know where my code went wrong, I keep getting dataset a variables.  That's it.  Where is the set b?

1. The reason had already been explained to you, and you also have notes in your log explaining the reason: rename your duplicate variables

select A.*, B.DUPNAME as DUPNAME_B