SAS Programming help

Reply
Occasional Contributor
Posts: 13

SAS Programming help

Hi,

 

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

 

1st Dataset:

key1key2
101901
101902
101903
101904
101905
102801
102802
102803
102804

 

2nd Dataset:

key1key3key4var1var2var3var4var5varn
101a1b1......
101a2b2......
101a3b3......
102a4b4......
102a5b5......
102a6b6......

 

Desired output dataset:

 

key2key1key3key4var1var2var3var4var5varn
901101a1b1......
901101a2b2......
901101a3b3......
902101a1b1......
902101a2b2......
902101a3b3......
903101a1b1......
903101a2b2......
903101a3b3......
801102a4b4......
801102a5b5......
801102a6b6......
802102a4b4......
802102a5b5......
802102a6b6......
803102a4b4......
803102a5b5......
803102a6b6......
804102a4b4......
804102a5b5......
804102a6b6......

 

Thanks for your time and help.

John

Trusted Advisor
Posts: 1,147

Re: SAS Programming help

Posted in reply to InnovativeMinds
This is a duplicate post I believe, a similar post has been responded.
Thanks,
Jag
PROC Star
Posts: 2,329

Re: SAS Programming help

Posted in reply to InnovativeMinds

Do no post several times please.

Ask a Question
Discussion stats
  • 2 replies
  • 150 views
  • 1 like
  • 3 in conversation