topic merging ? in SAS Programming

merging ?

desireatem — Fri, 10 Jan 2014 20:45:35 GMT

Data A ;

Input a b;

Cards;

2 .9

4 .8

9 .3

Data b

Input c;

Input a;

Cards;

1.9

4.7

8.8;

Merge them to have:

1.9 .

2 .9

4 .8

4.7 .

8.8 .

9 .3

Thanks

Re: merging ?

Tom — Fri, 10 Jan 2014 21:07:40 GMT

Just use MERGE statement.

Data A ;

Input a b;

Cards;

2 .9

4 .8

9 .3

run;

Data b;

Input a;

Cards;

1.9

4.7

8.8

run;

data c;

merge a b;

by a ;

run;

Re: merging ?

Jagadishkatam — Sun, 12 Jan 2014 09:18:58 GMT

Alternatively by SQL

PROC SQL;

CREATE TABLE want AS

SELECT coalesce(t2.a,t1.a) AS a,

t1.b

FROM WORK.A t1

FULL JOIN WORK.B t2 ON (t1.a = t2.a);

QUIT;

Thanks,

Jag