topic Tranpose dataset in SAS Programming

topic Tranpose dataset in SAS Programming https://communities.sas.com/t5/SAS-Programming/Tranpose-dataset/m-p/87317#M18653 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a dataset which is a crossbat between age group (in row, 16 categories) and municipality (in line, 79 categories):</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 560px;"><TBODY><TR><TD class="xl24" height="17" width="80"></TD><TD class="xl25" width="80">1</TD><TD class="xl25" width="80">2</TD><TD class="xl25" width="80">3</TD><TD class="xl25" width="80">4</TD><TD class="xl25" width="80">…</TD><TD class="xl25" width="80">16</TD></TR><TR><TD class="xl26" height="17">1</TD><TD class="xl26">245</TD><TD class="xl26">285</TD><TD class="xl26">335</TD><TD class="xl26">340</TD><TD class="xl26">320</TD><TD class="xl26">290</TD></TR><TR><TD class="xl26" height="17">2</TD><TD class="xl26">250</TD><TD class="xl26">255</TD><TD class="xl26">305</TD><TD class="xl26">300</TD><TD class="xl26">240</TD><TD class="xl26">320</TD></TR><TR><TD class="xl26" height="17">3</TD><TD class="xl26">1470</TD><TD class="xl26">1560</TD><TD class="xl26">2020</TD><TD class="xl26">1600</TD><TD class="xl26">1255</TD><TD class="xl26">1570</TD></TR><TR><TD class="xl26" height="17">4</TD><TD class="xl26">520</TD><TD class="xl26">535</TD><TD class="xl26">580</TD><TD class="xl26">475</TD><TD class="xl26">375</TD><TD class="xl26">365</TD></TR><TR><TD class="xl26" height="17">5</TD><TD class="xl26">1190</TD><TD class="xl26">1125</TD><TD class="xl26">1280</TD><TD class="xl26">1040</TD><TD class="xl26">770</TD><TD class="xl26">1065</TD></TR><TR><TD class="xl26" height="17">…</TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD></TR><TR><TD class="xl26" height="17">79</TD><TD class="xl26">1395</TD><TD class="xl26">1695</TD><TD class="xl26">2130</TD><TD class="xl26">2150</TD><TD class="xl26">1870</TD><TD class="xl26">1265</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to transpose it in a data set of 3 rows and 79*16 lines:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="240"><TBODY><TR><TD class="xl24" height="17" width="80">Municipality</TD><TD class="xl24" width="80">Age Group</TD><TD class="xl24" width="80">Population</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">1</TD><TD class="xl24">245</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">2</TD><TD class="xl24">285</TD></TR><TR><TD class="xl24" height="17">,,</TD><TD class="xl24">,,</TD><TD class="xl24">…</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">79</TD><TD class="xl24">290</TD></TR><TR><TD class="xl24" height="17">,,,</TD><TD class="xl24">,,,</TD><TD class="xl24">…</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">14</TD><TD class="xl24">1687</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">15</TD><TD class="xl24">1543</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">16</TD><TD class="xl24">1265</TD></TR></TBODY></TABLE><P></P><P>I'm sure it's easy, but I just don't know how.</P></BODY></HTML> Tue, 23 Jul 2013 21:47:53 GMT Demographer 2013-07-23T21:47:53Z Tranpose dataset https://communities.sas.com/t5/SAS-Programming/Tranpose-dataset/m-p/87317#M18653 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have a dataset which is a crossbat between age group (in row, 16 categories) and municipality (in line, 79 categories):</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 560px;"><TBODY><TR><TD class="xl24" height="17" width="80"></TD><TD class="xl25" width="80">1</TD><TD class="xl25" width="80">2</TD><TD class="xl25" width="80">3</TD><TD class="xl25" width="80">4</TD><TD class="xl25" width="80">…</TD><TD class="xl25" width="80">16</TD></TR><TR><TD class="xl26" height="17">1</TD><TD class="xl26">245</TD><TD class="xl26">285</TD><TD class="xl26">335</TD><TD class="xl26">340</TD><TD class="xl26">320</TD><TD class="xl26">290</TD></TR><TR><TD class="xl26" height="17">2</TD><TD class="xl26">250</TD><TD class="xl26">255</TD><TD class="xl26">305</TD><TD class="xl26">300</TD><TD class="xl26">240</TD><TD class="xl26">320</TD></TR><TR><TD class="xl26" height="17">3</TD><TD class="xl26">1470</TD><TD class="xl26">1560</TD><TD class="xl26">2020</TD><TD class="xl26">1600</TD><TD class="xl26">1255</TD><TD class="xl26">1570</TD></TR><TR><TD class="xl26" height="17">4</TD><TD class="xl26">520</TD><TD class="xl26">535</TD><TD class="xl26">580</TD><TD class="xl26">475</TD><TD class="xl26">375</TD><TD class="xl26">365</TD></TR><TR><TD class="xl26" height="17">5</TD><TD class="xl26">1190</TD><TD class="xl26">1125</TD><TD class="xl26">1280</TD><TD class="xl26">1040</TD><TD class="xl26">770</TD><TD class="xl26">1065</TD></TR><TR><TD class="xl26" height="17">…</TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD><TD class="xl26"></TD></TR><TR><TD class="xl26" height="17">79</TD><TD class="xl26">1395</TD><TD class="xl26">1695</TD><TD class="xl26">2130</TD><TD class="xl26">2150</TD><TD class="xl26">1870</TD><TD class="xl26">1265</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to transpose it in a data set of 3 rows and 79*16 lines:</P><TABLE border="0" cellpadding="0" cellspacing="0" width="240"><TBODY><TR><TD class="xl24" height="17" width="80">Municipality</TD><TD class="xl24" width="80">Age Group</TD><TD class="xl24" width="80">Population</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">1</TD><TD class="xl24">245</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">2</TD><TD class="xl24">285</TD></TR><TR><TD class="xl24" height="17">,,</TD><TD class="xl24">,,</TD><TD class="xl24">…</TD></TR><TR><TD class="xl24" height="17">1</TD><TD class="xl24">79</TD><TD class="xl24">290</TD></TR><TR><TD class="xl24" height="17">,,,</TD><TD class="xl24">,,,</TD><TD class="xl24">…</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">14</TD><TD class="xl24">1687</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">15</TD><TD class="xl24">1543</TD></TR><TR><TD class="xl24" height="17">79</TD><TD class="xl24">16</TD><TD class="xl24">1265</TD></TR></TBODY></TABLE><P></P><P>I'm sure it's easy, but I just don't know how.</P></BODY></HTML> Tue, 23 Jul 2013 21:47:53 GMT https://communities.sas.com/t5/SAS-Programming/Tranpose-dataset/m-p/87317#M18653 Demographer 2013-07-23T21:47:53Z Re: Tranpose dataset https://communities.sas.com/t5/SAS-Programming/Tranpose-dataset/m-p/87318#M18654 <HTML><HEAD></HEAD><BODY><P>Transpose using either data step or proc transpose:</P><P></P><P><A href="http://www.ats.ucla.edu/stat/sas/modules/wtol_transpose.htm" title="http://www.ats.ucla.edu/stat/sas/modules/wtol_transpose.htm">SAS Learning Module: How to reshape data wide to long using proc transpose</A></P><P></P><P><A href="http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm" title="http://www.ats.ucla.edu/stat/sas/modules/widetolong_data.htm">SAS Learning Module: Reshaping wide to long using a data step</A></P></BODY></HTML> Tue, 23 Jul 2013 21:50:44 GMT https://communities.sas.com/t5/SAS-Programming/Tranpose-dataset/m-p/87318#M18654 Reeza 2013-07-23T21:50:44Z