SAS Programming help

Reply
New Contributor
Posts: 4

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

Super User
Posts: 1,117

Re: SAS Programming help

This is a duplicate post I believe, a similar post has been responded.
Thanks,
Jag
Trusted Advisor
Posts: 1,514

Re: SAS Programming help

Do no post several times please.

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