topic Re: Transpose in SAS Procedures

topic Re: Transpose in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Transpose/m-p/328517#M62497 <P>Proc transpose makes that an easy task. e.g.:</P> <P> </P> <PRE>proc transpose data=have out=want (rename=(_name_=seq col1=value)); var rg--jb; by number notsorted; run; </PRE> <P>HTH,</P> <P>Art, CEO, AnalystFinder.com</P> <P> </P> Mon, 30 Jan 2017 17:18:58 GMT art297 2017-01-30T17:18:58Z Transpose https://communities.sas.com/t5/SAS-Procedures/Transpose/m-p/328514#M62496 <P>HI, I have a table like below and want it to be transposed like the "WANT" table below. Please suggest. </P> <P> </P> <P> </P> <P> </P> <TABLE style="border-collapse: collapse; width: 315pt;" border="0" width="420" cellspacing="0" cellpadding="0"><COLGROUP><COL style="width: 45pt;" span="7" width="60" /> </COLGROUP> <TBODY> <TR style="height: 15.0pt;"> <TD width="60" height="20" class="xl66" style="height: 15.0pt; width: 45pt;">HAVE</TD> <TD width="60" style="width: 45pt;"> </TD> <TD width="60" style="width: 45pt;"> </TD> <TD width="60" style="width: 45pt;"> </TD> <TD width="60" style="width: 45pt;"> </TD> <TD width="60" style="width: 45pt;"> </TD> <TD width="60" style="width: 45pt;"> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;"> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt;">number</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">RG</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">LB</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">PM</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">AR</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">VL</TD> <TD width="60" class="xl67" style="border-left: none; width: 45pt;">JB</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">y</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">y</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD width="60" class="xl69" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;"> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl70" style="height: 15.0pt;">WANT</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" style="height: 15.0pt;"> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt;">number</TD> <TD class="xl64" style="border-left: none;">seq</TD> <TD class="xl64" style="border-left: none;">value</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">RG</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">LB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">PM</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">AR</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">VL</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9001</TD> <TD class="xl64" style="border-top: none; border-left: none;">JB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">RG</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">LB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">PM</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">AR</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">VL</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9002</TD> <TD class="xl64" style="border-top: none; border-left: none;">JB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">b</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">RG</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">LB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">PM</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">AR</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">VL</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">y</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9003</TD> <TD class="xl64" style="border-top: none; border-left: none;">JB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">RG</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">y</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">LB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">PM</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">AR</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">VL</TD> <TD width="60" class="xl69" style="border-top: none; border-left: none; width: 45pt;">a</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> <TR style="height: 15.0pt;"> <TD height="20" class="xl65" style="height: 15.0pt; border-top: none;">9004</TD> <TD class="xl64" style="border-top: none; border-left: none;">JB</TD> <TD width="60" class="xl68" style="border-top: none; border-left: none; width: 45pt;">x</TD> <TD> </TD> <TD> </TD> <TD> </TD> <TD> </TD> </TR> </TBODY> </TABLE> Mon, 30 Jan 2017 17:11:04 GMT https://communities.sas.com/t5/SAS-Procedures/Transpose/m-p/328514#M62496 helloSAS 2017-01-30T17:11:04Z Re: Transpose https://communities.sas.com/t5/SAS-Procedures/Transpose/m-p/328517#M62497 <P>Proc transpose makes that an easy task. e.g.:</P> <P> </P> <PRE>proc transpose data=have out=want (rename=(_name_=seq col1=value)); var rg--jb; by number notsorted; run; </PRE> <P>HTH,</P> <P>Art, CEO, AnalystFinder.com</P> <P> </P> Mon, 30 Jan 2017 17:18:58 GMT https://communities.sas.com/t5/SAS-Procedures/Transpose/m-p/328517#M62497 art297 2017-01-30T17:18:58Z