Transpose Array

[aidant01]

Hi, 

I am trying to convert the 'have' dataset into the following 'want' dataset. Any help will be appreciated. Thanks!

HAVE
id	address1streetnum	address1streetname	address1city	address1zip	address2streetnum	address2streetname	address2city	address2zip
101	215	Market Street	San Francisco	94016	16	Main Street	New York	10001
102	957	Market Street	San Francisco	94016	12	Main Street	New York	10001
WANT
id	addressstreetnum	addressstreetname	addresscity	addresszip	address_num
101	215	Market Street	San Francisco	94016	1
101	16	Main Street	New York	10001	2
102	957	Market Street	San Francisco	94016	1
102	12	Main Street	New York	10001	2

[Reeza · Accepted solution]

Are all your field types character?

You're essentially trying to do Example 3 here but with more variables.
https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/