DATA Step, Macro, Functions and more

Adding a column

Accepted Solution Solved
Reply
Contributor
Posts: 50
Accepted Solution

Adding a column

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


Accepted Solutions
Solution
‎07-24-2016 04:14 PM
Respected Advisor
Posts: 4,646

Re: Adding a column

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

PG

View solution in original post


All Replies
Contributor
Posts: 50

Re: Adding a column

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

 

data C;
merge A B;
run;

 

KR

SK

Solution
‎07-24-2016 04:14 PM
Respected Advisor
Posts: 4,646

Re: Adding a column

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

PG
Respected Advisor
Posts: 4,646

Re: Adding a column

Oh well... Smiley Embarassed

PG
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 218 views
  • 0 likes
  • 2 in conversation