Desktop productivity for business analysts and programmers

How to combine 2 data set

Reply
N/A
Posts: 0

How to combine 2 data set

I have 2 table, table A (200 records) & table B (100 records). 2 table have the same field - partno.
I like to update "Y" into a field available in table A if partno in A =partno in B. But I do not know how to write the statement. If anyone know, pls could you share it to me. Thanks a lot
New Contributor
Posts: 3

Re: How to combine 2 data set

Assuming you want to keep table A as is, and then add a field Y from table B where partno matches.

proc sql;
create table NEWTABLE as
select
A.*,
B.Y
from
A

left join B
on A.partno = B.partno
;
quit;
Esteemed Advisor
Posts: 5,198

Re: How to combine 2 data set

Maybe this is a little closer...:

proc sql;
create table NEWTABLE as
select
A.*,
case B.partno
when . then 'N'
else 'Y'
end as updated
from A
left join B
on A.partno = B.partno
;
quit;

Regards,
Linus
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 84 views
  • 0 likes
  • 3 in conversation