How to combine 2 data set

[deleted_user]

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

[david_offlode]

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;

[LinusH]

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