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
Do no post several times please.
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.