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
You are allowed (encouraged even) to mark your own solution as accepted . Please do!
Ok, I figured out, it's not complicated at all! just using a simple merge :
data C;
merge A B;
run;
KR
SK
You are allowed (encouraged even) to mark your own solution as accepted . Please do!
Oh well...
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.