Adding a column

[Siddharth123]

Hello All,

I am wondering if it is possible to solve this problem in SAS. I have two datasets - A & B both having same observations. I want to add all columns from Data B to Data A (given there is no matching ID in two datasets):

Data A:

var1 var2

1       2

3       4

5       6

Data B:

var3:

7

8

9

Data C:

var1 var2   var3

1       2         7

3       4         8

5       6         9

Is this possible to do in SAS? I thought of using Proc IML? Is there any SAS Datset procedure to do this?

KR

SK

[Siddharth123]

Ok, I figured out, it's not complicated at all! just using a simple merge :

data C;
merge A B;
run;

KR

SK

[PGStats · Accepted solution]

You are allowed (encouraged even) to mark your own solution as accepted . Please do!

[PGStats]

Oh well...