topic Re: Transpose Array in SAS Programming https://communities.sas.com/t5/SAS-Programming/Transpose-Array/m-p/744834#M233399 Are all your field types character?<BR /><BR />You're essentially trying to do Example 3 here but with more variables. <BR /><A href="https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/" target="_blank">https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/</A> Mon, 31 May 2021 20:51:35 GMT Reeza 2021-05-31T20:51:35Z Transpose Array https://communities.sas.com/t5/SAS-Programming/Transpose-Array/m-p/744832#M233397 <P>Hi,&nbsp;</P><P>&nbsp;</P><P>I am trying to convert the 'have' dataset into the following 'want' dataset. Any help will be appreciated. Thanks!</P><P>&nbsp;</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>HAVE</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>id</TD><TD>address1streetnum</TD><TD>address1streetname</TD><TD>address1city</TD><TD>address1zip</TD><TD>address2streetnum</TD><TD>address2streetname</TD><TD>address2city</TD><TD>address2zip</TD></TR><TR><TD>101</TD><TD>215</TD><TD>Market Street<SPAN>&nbsp;</SPAN></TD><TD>San Francisco</TD><TD>94016</TD><TD>16</TD><TD>Main Street</TD><TD>New York<SPAN>&nbsp;</SPAN></TD><TD>10001</TD></TR><TR><TD>102</TD><TD>957</TD><TD>Market Street<SPAN>&nbsp;</SPAN></TD><TD>San Francisco</TD><TD>94016</TD><TD>12</TD><TD>Main Street</TD><TD>New York<SPAN>&nbsp;</SPAN></TD><TD>10001</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>WANT</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>id</TD><TD>addressstreetnum</TD><TD>addressstreetname</TD><TD>addresscity</TD><TD>addresszip</TD><TD>address_num</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>101</TD><TD>215</TD><TD>Market Street<SPAN>&nbsp;</SPAN></TD><TD>San Francisco</TD><TD>94016</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>101</TD><TD>16</TD><TD>Main Street</TD><TD>New York<SPAN>&nbsp;</SPAN></TD><TD>10001</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>102</TD><TD>957</TD><TD>Market Street<SPAN>&nbsp;</SPAN></TD><TD>San Francisco</TD><TD>94016</TD><TD>1</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>102</TD><TD>12</TD><TD>Main Street</TD><TD>New York<SPAN>&nbsp;</SPAN></TD><TD>10001</TD><TD>2</TD><TD>&nbsp;</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR></TBODY></TABLE> Mon, 31 May 2021 20:43:55 GMT https://communities.sas.com/t5/SAS-Programming/Transpose-Array/m-p/744832#M233397 aidant01 2021-05-31T20:43:55Z Re: Transpose Array https://communities.sas.com/t5/SAS-Programming/Transpose-Array/m-p/744834#M233399 Are all your field types character?<BR /><BR />You're essentially trying to do Example 3 here but with more variables. <BR /><A href="https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/" target="_blank">https://stats.idre.ucla.edu/sas/modules/reshaping-data-wide-to-long-using-a-data-step/</A> Mon, 31 May 2021 20:51:35 GMT https://communities.sas.com/t5/SAS-Programming/Transpose-Array/m-p/744834#M233399 Reeza 2021-05-31T20:51:35Z