topic Adding a column in SAS Programming

Adding a column

Siddharth123 — Sun, 24 Jul 2016 08:05:51 GMT

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:

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?

Re: Adding a column

Siddharth123 — Sun, 24 Jul 2016 08:11:57 GMT

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

data C;
merge A B;
run;

Re: Adding a column

PGStats — Sun, 24 Jul 2016 17:10:10 GMT

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

Re: Adding a column

PGStats — Sun, 24 Jul 2016 21:21:17 GMT

Oh well...