topic transpose across vars in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/transpose-across-vars/m-p/50964#M13926 <HTML><HEAD></HEAD><BODY><P>I'm trying to use trnspose, but may be the wrong procedure.&nbsp; I'm trying to bring the top variables all into a column.</P><P></P><P>Have:</P><P></P><P><SPAN style="text-decoration: underline;">Area</SPAN>&nbsp; <SPAN style="text-decoration: underline;">Va1</SPAN>&nbsp; <SPAN style="text-decoration: underline;">Va2</SPAN>&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Va3 ... Va54</SPAN></P><P>NY&nbsp;&nbsp;&nbsp;&nbsp; 3.4&nbsp;&nbsp;&nbsp; 5.3&nbsp;&nbsp;&nbsp; 6.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.5</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp; 2.3&nbsp;&nbsp;&nbsp;&nbsp; 5.4&nbsp;&nbsp; 5.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.7</P><P></P><P>Want:</P><P></P><P><SPAN style="text-decoration: underline;">Area</SPAN>&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Var</SPAN>&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Price</SPAN></P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va1&nbsp;&nbsp;&nbsp;&nbsp; 3.4</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va2&nbsp;&nbsp;&nbsp;&nbsp; 5.3</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va3&nbsp;&nbsp;&nbsp;&nbsp; 6.7</P><P>...</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va54&nbsp;&nbsp; 2.5</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va1&nbsp;&nbsp;&nbsp; 2.3</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va2&nbsp;&nbsp;&nbsp; 5.4</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va3&nbsp;&nbsp;&nbsp; 5.3</P><P>...</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va54&nbsp; 3.7</P><P></P><P>thanks</P></BODY></HTML> Sun, 20 Nov 2011 16:19:06 GMT podarum 2011-11-20T16:19:06Z transpose across vars https://communities.sas.com/t5/SAS-Procedures/transpose-across-vars/m-p/50964#M13926 <HTML><HEAD></HEAD><BODY><P>I'm trying to use trnspose, but may be the wrong procedure.&nbsp; I'm trying to bring the top variables all into a column.</P><P></P><P>Have:</P><P></P><P><SPAN style="text-decoration: underline;">Area</SPAN>&nbsp; <SPAN style="text-decoration: underline;">Va1</SPAN>&nbsp; <SPAN style="text-decoration: underline;">Va2</SPAN>&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Va3 ... Va54</SPAN></P><P>NY&nbsp;&nbsp;&nbsp;&nbsp; 3.4&nbsp;&nbsp;&nbsp; 5.3&nbsp;&nbsp;&nbsp; 6.7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2.5</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp; 2.3&nbsp;&nbsp;&nbsp;&nbsp; 5.4&nbsp;&nbsp; 5.3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3.7</P><P></P><P>Want:</P><P></P><P><SPAN style="text-decoration: underline;">Area</SPAN>&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Var</SPAN>&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">Price</SPAN></P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va1&nbsp;&nbsp;&nbsp;&nbsp; 3.4</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va2&nbsp;&nbsp;&nbsp;&nbsp; 5.3</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va3&nbsp;&nbsp;&nbsp;&nbsp; 6.7</P><P>...</P><P>NY&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va54&nbsp;&nbsp; 2.5</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va1&nbsp;&nbsp;&nbsp; 2.3</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va2&nbsp;&nbsp;&nbsp; 5.4</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va3&nbsp;&nbsp;&nbsp; 5.3</P><P>...</P><P>LA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Va54&nbsp; 3.7</P><P></P><P>thanks</P></BODY></HTML> Sun, 20 Nov 2011 16:19:06 GMT https://communities.sas.com/t5/SAS-Procedures/transpose-across-vars/m-p/50964#M13926 podarum 2011-11-20T16:19:06Z transpose across vars https://communities.sas.com/t5/SAS-Procedures/transpose-across-vars/m-p/50965#M13927 <HTML><HEAD></HEAD><BODY><P>You could use proc transpose.&nbsp; e.g.,</P><P></P><P>proc transpose data=have</P><P>&nbsp; out=want (rename=(_name_=var col1=price));</P><P>&nbsp; var Va1--Va54;</P><P>&nbsp; by Area notsorted;</P><P>run;</P></BODY></HTML> Sun, 20 Nov 2011 16:43:26 GMT https://communities.sas.com/t5/SAS-Procedures/transpose-across-vars/m-p/50965#M13927 art297 2011-11-20T16:43:26Z