SAS Programming help

[InnovativeMinds]

Hi,

I have two datasets and want to produce third dataset like mentioned below.

1st Dataset:

key1	key2
101	901
101	902
101	903
101	904
101	905
102	801
102	802
102	803
102	804

2nd Dataset:

key1	key3	key4	var1	var2	var3	var4	var5	varn
101	a1	b1	.	.	.	.	.	.
101	a2	b2	.	.	.	.	.	.
101	a3	b3	.	.	.	.	.	.
102	a4	b4	.	.	.	.	.	.
102	a5	b5	.	.	.	.	.	.
102	a6	b6	.	.	.	.	.	.

Desired output dataset:

key2	key1	key3	key4	var1	var2	var3	var4	var5	varn
901	101	a1	b1	.	.	.	.	.	.
901	101	a2	b2	.	.	.	.	.	.
901	101	a3	b3	.	.	.	.	.	.
902	101	a1	b1	.	.	.	.	.	.
902	101	a2	b2	.	.	.	.	.	.
902	101	a3	b3	.	.	.	.	.	.
903	101	a1	b1	.	.	.	.	.	.
903	101	a2	b2	.	.	.	.	.	.
903	101	a3	b3	.	.	.	.	.	.
801	102	a4	b4	.	.	.	.	.	.
801	102	a5	b5	.	.	.	.	.	.
801	102	a6	b6	.	.	.	.	.	.
802	102	a4	b4	.	.	.	.	.	.
802	102	a5	b5	.	.	.	.	.	.
802	102	a6	b6	.	.	.	.	.	.
803	102	a4	b4	.	.	.	.	.	.
803	102	a5	b5	.	.	.	.	.	.
803	102	a6	b6	.	.	.	.	.	.
804	102	a4	b4	.	.	.	.	.	.
804	102	a5	b5	.	.	.	.	.	.
804	102	a6	b6	.	.	.	.	.	.

Thanks for your time and help.

John

[Jagadishkatam]

This is a duplicate post I believe, a similar post has been responded.

[ChrisNZ]

Do no post several times please.