Left join conditions

[Smitha9]

Dataset A:

ID       Episode

1          1000

2         3000

3        4000

4       5000

Dataset B:

ID  Episode

1      1000

2      2000

3      7000

5     9000

Proc Sql;

create table check as

select a.*,b.*

from datasetA as a on a.ID=b.ID and a.Episode=b.Episode

where b.ID-NULL and b.Episode=NULL

;

quit;

Please let me know the result and how it works. thank you in advance.

[Kurt_Bremser]

Maxim 4. Try It.

Read the log, correct your mistakes, rinse, repeat.

First hint: b.* cannot work, as both variables are already coming from a.