topic Re: Join two tables ???? in SAS Programming

Join two tables ????

devnand — Tue, 15 Jul 2014 20:28:12 GMT

HI all,

I have two tables,

data test;

infile datalines;

input obs product $ quantity;

datalines;

1 A 2

2 B 3

3 C 5

4 D 6

;

run;

data test2;

infile datalines;

input obs product $ quantity;

datalines;

1 A 5

2 D 8

;

run;

I want to create a datasets as follows:

1 A 5

2 B 3

3 C 5

4 D 8

A and D gets updated value from test2? Is there way to achieve this using PROC SQL??

Thanks for the help in advance..

Re: Join two tables ????

Reeza — Tue, 15 Jul 2014 20:35:37 GMT

Why SQL? This is easier in a data step.

Re: Join two tables ????

stat_sas — Tue, 15 Jul 2014 21:00:23 GMT

Try this.

proc sql;

select a.obs,a.product,COALESCE(b.quantity,a.quantity)

from test a left join test2 b

on a.product=b.product;

quit;

Re: Join two tables ????

slchen — Tue, 15 Jul 2014 21:01:54 GMT

proc sql;
update test as a
set quantity=(select quantity from test2 b where a.product=b.product) where a.product in (select product from test2);
quit;

data test;
update test test2;
by product;
run;

Re: Join two tables ????

devnand — Tue, 15 Jul 2014 21:33:52 GMT

thank you all for your suggestion