topic Transpose data in SAS Programming

topic Transpose data in SAS Programming https://communities.sas.com/t5/SAS-Programming/Transpose-data/m-p/302116#M64026 <P>I need to transpose this table to other table i typed:</P> <P> </P> <TABLE width="217"> <TBODY> <TR> <TD width="64">id</TD> <TD width="64">grade</TD> <TD width="89">course</TD> </TR> <TR> <TD>12</TD> <TD>A</TD> <TD>HUM1020</TD> </TR> <TR> <TD>15</TD> <TD>B</TD> <TD>HUM1020</TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>ENC1101</TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>HUM1020</TD> </TR> <TR> <TD>17</TD> <TD>B</TD> <TD>MAT2020</TD> </TR> </TBODY> </TABLE> <P> </P> <P>i need to transpose this table to this table:</P> <TABLE width="281"> <TBODY> <TR> <TD width="64">id</TD> <TD width="64">HUM1020</TD> <TD width="89">ENC1101</TD> <TD width="64">MAT2020</TD> </TR> <TR> <TD>12</TD> <TD>A</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>15</TD> <TD>B</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>A</TD> <TD>B</TD> </TR> </TBODY> </TABLE> Mon, 03 Oct 2016 17:46:58 GMT user24 2016-10-03T17:46:58Z Transpose data https://communities.sas.com/t5/SAS-Programming/Transpose-data/m-p/302116#M64026 <P>I need to transpose this table to other table i typed:</P> <P> </P> <TABLE width="217"> <TBODY> <TR> <TD width="64">id</TD> <TD width="64">grade</TD> <TD width="89">course</TD> </TR> <TR> <TD>12</TD> <TD>A</TD> <TD>HUM1020</TD> </TR> <TR> <TD>15</TD> <TD>B</TD> <TD>HUM1020</TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>ENC1101</TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>HUM1020</TD> </TR> <TR> <TD>17</TD> <TD>B</TD> <TD>MAT2020</TD> </TR> </TBODY> </TABLE> <P> </P> <P>i need to transpose this table to this table:</P> <TABLE width="281"> <TBODY> <TR> <TD width="64">id</TD> <TD width="64">HUM1020</TD> <TD width="89">ENC1101</TD> <TD width="64">MAT2020</TD> </TR> <TR> <TD>12</TD> <TD>A</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>15</TD> <TD>B</TD> <TD> </TD> <TD> </TD> </TR> <TR> <TD>17</TD> <TD>A</TD> <TD>A</TD> <TD>B</TD> </TR> </TBODY> </TABLE> Mon, 03 Oct 2016 17:46:58 GMT https://communities.sas.com/t5/SAS-Programming/Transpose-data/m-p/302116#M64026 user24 2016-10-03T17:46:58Z Re: Transpose data https://communities.sas.com/t5/SAS-Programming/Transpose-data/m-p/302124#M64031 <P>PROC TRANSPOSE should be able to handle this, as long as the data is in order by ID:</P> <P> </P> <P>proc transpose data=have out=want (drop=_name_);</P> <P>   var grade;</P> <P>   by id;</P> <P>   id course;</P> <P>run;</P> <P> </P> <P> </P> Mon, 03 Oct 2016 18:11:35 GMT https://communities.sas.com/t5/SAS-Programming/Transpose-data/m-p/302124#M64031 Astounding 2016-10-03T18:11:35Z