topic Re: How to combine 2 data set in SAS Enterprise Guide

How to combine 2 data set

deleted_user — Thu, 07 Aug 2008 03:29:20 GMT

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

Re: How to combine 2 data set

david_offlode — Thu, 07 Aug 2008 08:52:50 GMT

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;

Re: How to combine 2 data set

LinusH — Mon, 18 Aug 2008 11:23:26 GMT

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