Merging 2 datesets with overlap

radhikaa4 — Tue, 07 May 2019 16:57:41 GMT

Hello,

I have 2 datasets and I would like to create 3rd dataset

Dataset #1

Dataset #2

Want dataset #3

I tried the following

PROC SQL;

SELECT bb.*, cc.flag

FROM a.dataset_1 bb LEFT JOIN a.dataset_2 cc on bb.patientID = cc.patientID;

QUIT;

But it doesn't work or shows "flag = 1" for all the records. I also tried full outer join etc.

Thanks

Re: Merging 2 datesets with overlap

Reeza — Tue, 07 May 2019 16:59:46 GMT

Add a condition to join on date as well.

and bb.date=cc.date