I have 2 files that look like this:
CustID ContactID
1 1
1 2
1 3
CustID PlanID
1 A
1 B
1 C
I need to merge them in base SAS so I get the following:
CustID ContcatID PlanID
1 1 A
1 1 B
1 1 C
1 2 A
1 2 B
1 2 C
1 3 A
1 3 B
1 3 C
You might lookup Cartesian Products in SAS.
like this?
data one;
input CustID ContactID;
datalines;
1 1
1 2
1 3
;
data two;
input CustID PlanID$;
datalines;
1 A
1 B
1 C
;
proc sql;
create table want as
select one.*
,two.planID
from one, two
where one.CustID=two.CustID
order by CustID, ContactID, planID;
quit;
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.