https://communities.sas.com/t5/SAS-Procedures/Transpose-from-long-to-wide-by-two-variables/m-p/712539#M80029 <P>Can some one help me with a syntax to transpose from long to wide by two variables.&nbsp;</P><P>I have following dataset (example):&nbsp;</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; Matnr&nbsp; &nbsp; &nbsp;Code&nbsp; &nbsp;</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P200</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T500</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M870</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871&nbsp;</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T800</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T812</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M871<BR /><BR />I would like it to be transposed by ID and Matnr. like:&nbsp;</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; Matnr&nbsp; &nbsp; &nbsp;Code_1&nbsp; &nbsp; Code_2&nbsp; &nbsp; &nbsp;Code_3&nbsp; &nbsp; &nbsp;Code_4</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200&nbsp; &nbsp; &nbsp; &nbsp; T500&nbsp; &nbsp; &nbsp; &nbsp; M870&nbsp; &nbsp;&nbsp;</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400&nbsp; &nbsp; &nbsp; &nbsp; M871</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400&nbsp; &nbsp; &nbsp; &nbsp;M871</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200&nbsp; &nbsp; &nbsp; &nbsp;T800&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T812&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Tue, 19 Jan 2021 22:43:44 GMT MABRINCH 2021-01-19T22:43:44Z https://communities.sas.com/t5/SAS-Procedures/Transpose-from-long-to-wide-by-two-variables/m-p/712539#M80029 <P>Can some one help me with a syntax to transpose from long to wide by two variables.&nbsp;</P><P>I have following dataset (example):&nbsp;</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; Matnr&nbsp; &nbsp; &nbsp;Code&nbsp; &nbsp;</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; P200</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; T500</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M870</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871&nbsp;</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T800</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T812</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; M871<BR /><BR />I would like it to be transposed by ID and Matnr. like:&nbsp;</P><P>&nbsp;</P><P>ID&nbsp; &nbsp; Matnr&nbsp; &nbsp; &nbsp;Code_1&nbsp; &nbsp; Code_2&nbsp; &nbsp; &nbsp;Code_3&nbsp; &nbsp; &nbsp;Code_4</P><P>19&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200&nbsp; &nbsp; &nbsp; &nbsp; T500&nbsp; &nbsp; &nbsp; &nbsp; M870&nbsp; &nbsp;&nbsp;</P><P>19&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400&nbsp; &nbsp; &nbsp; &nbsp; M871</P><P>20&nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P400&nbsp; &nbsp; &nbsp; &nbsp;M871</P><P>20&nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;P200&nbsp; &nbsp; &nbsp; &nbsp;T800&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;T812&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;M871&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</P> Tue, 19 Jan 2021 22:43:44 GMT https://communities.sas.com/t5/SAS-Procedures/Transpose-from-long-to-wide-by-two-variables/m-p/712539#M80029 MABRINCH 2021-01-19T22:43:44Z https://communities.sas.com/t5/SAS-Procedures/Transpose-from-long-to-wide-by-two-variables/m-p/712540#M80030 <P>If your data is sorted correctly you should be fine with</P> <P>&nbsp;</P> <P>Proc sort data=source out=transposed</P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; prefix=Code_</P> <P>;</P> <P>by id matnr;</P> <P>var code;</P> <P>run;</P> Tue, 19 Jan 2021 22:49:48 GMT https://communities.sas.com/t5/SAS-Procedures/Transpose-from-long-to-wide-by-two-variables/m-p/712540#M80030 ballardw 2021-01-19T22:49:48Z