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...
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.