DATA Step, Macro, Functions and more

Adding a column

Accepted Solution Solved
Reply
Contributor
Posts: 57
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,920

Re: Adding a column

Posted in reply to Siddharth123

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: 57

Re: Adding a column

Posted in reply to Siddharth123

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,920

Re: Adding a column

Posted in reply to Siddharth123

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

PG
Respected Advisor
Posts: 4,920

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
  • 219 views
  • 0 likes
  • 2 in conversation