merging ?

[desireatem]

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

[Tom]

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;

[Jagadishkatam]

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