topic Re: joining multiple tables in SAS Programming

joining multiple tables

pacman94 — Sun, 25 Jul 2021 19:11:34 GMT

Hello I have 3 datasets and as you can see, Ids from one table compared to another is not always the case.

I need to merge all 3 datasets by id and if variable(s) don't exist then they need to be blank:

Dataset1:

Dataset2:

Dataset3

Want

What i have done so far is the following:

proc sql;

create table uniqueID as

select distinct ID from dataset1 union

select distinct ID from dataset2 union

select distinct ID from dataset3 ;

quit;

then

proc sql;

select a.*, b.*, c.*

from uniqueID a

left join dataset1 b on a.ID = b.ID

left join dataset2 b on a.ID = b.ID

left join dataset3 c on a.ID = c.ID;

quit;

not geting what i look for.

PaigeMiller — Sun, 25 Jul 2021 19:38:57 GMT

not geting what i look for.

are there errors in the log?

Please provide data in a usable form, following these instructions. Screen captures are not usable.

Astounding — Sun, 25 Jul 2021 21:48:40 GMT

It looks like your data sets:

If that's the case, the solution is simple:

data want;
   merge dataset1 dataset2 dataset3;
   by id;
run;

If you might have multiple records for the same ID, we need to know more about what the final result should look like.