https://communities.sas.com/t5/SAS-Programming/Turn-rows-into-columns/m-p/591126#M169295 <PRE><CODE class=" language-sas">data have; input groupnumber $ numberingroup; datalines; group1 450 group2 256 group3 214 ; proc transpose data=have out=want(drop=_:); id groupnumber; var numberingroup; run;</CODE></PRE> Tue, 24 Sep 2019 10:51:24 GMT PeterClemmensen 2019-09-24T10:51:24Z https://communities.sas.com/t5/SAS-Programming/Turn-rows-into-columns/m-p/591118#M169292 <P>Hello,</P><P>Basically i have a dataset that i would like to transform so that my rows become columns.</P><P>here's the data:</P><P>&nbsp;</P><P>group number&nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; number of people in group</P><P>group1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;450</P><P>group2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;256</P><P>group3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;214</P><P>&nbsp;</P><P>and i would like this:</P><P>&nbsp;group1&nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; group2&nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; group3</P><P>450&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp;256&nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;214</P> Tue, 24 Sep 2019 09:56:17 GMT https://communities.sas.com/t5/SAS-Programming/Turn-rows-into-columns/m-p/591118#M169292 polpel 2019-09-24T09:56:17Z https://communities.sas.com/t5/SAS-Programming/Turn-rows-into-columns/m-p/591126#M169295 <PRE><CODE class=" language-sas">data have; input groupnumber $ numberingroup; datalines; group1 450 group2 256 group3 214 ; proc transpose data=have out=want(drop=_:); id groupnumber; var numberingroup; run;</CODE></PRE> Tue, 24 Sep 2019 10:51:24 GMT https://communities.sas.com/t5/SAS-Programming/Turn-rows-into-columns/m-p/591126#M169295 PeterClemmensen 2019-09-24T10:51:24Z