topic Re: adding multiple rows to multiple rows in SAS Programming

adding multiple rows to multiple rows

granthecht — Tue, 14 Nov 2017 04:15:56 GMT

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

Re: adding multiple rows to multiple rows

PhilC — Tue, 14 Nov 2017 14:23:18 GMT

You might lookup Cartesian Products in SAS.

Re: adding multiple rows to multiple rows

PeterClemmensen — Tue, 14 Nov 2017 14:32:28 GMT

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;

Re: adding multiple rows to multiple rows

Yavuz — Tue, 14 Nov 2017 15:16:52 GMT

You can also use "inner join" or "left join" clauses with proc sql