Left join conditions

Smitha9 — Tue, 31 Oct 2023 01:05:11 GMT

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.

Re: Left join conditions

Kurt_Bremser — Tue, 31 Oct 2023 07:07:13 GMT

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.