https://communities.sas.com/t5/SAS-Procedures/Problems-with-PROC-Transpose/m-p/41861#M10847 I have data that looks like this:<BR /> <BR /> location,label,value<BR /> 1,A,0<BR /> 1,B,1<BR /> 2,A,1<BR /> 2,B,0<BR /> <BR /> However, I would like to transpose it to make it look like this:<BR /> <BR /> location,A,B<BR /> 1,0,1<BR /> 2,1,0<BR /> <BR /> I have tried the following code, which gives me an error:<BR /> <BR /> PROC TRANSPOSE data=before out=after let;<BR /> by location;<BR /> id label;<BR /> RUN;<BR /> <BR /> Any help would be much appreciated. Thanks!<BR /> <BR /> -<BR /> <BR /> Nevermind, this code works fine.<BR /> <BR /> Message was edited by: JeffG Message was edited by: JeffG Thu, 31 Mar 2011 19:25:35 GMT JeffG 2011-03-31T19:25:35Z https://communities.sas.com/t5/SAS-Procedures/Problems-with-PROC-Transpose/m-p/41861#M10847 I have data that looks like this:<BR /> <BR /> location,label,value<BR /> 1,A,0<BR /> 1,B,1<BR /> 2,A,1<BR /> 2,B,0<BR /> <BR /> However, I would like to transpose it to make it look like this:<BR /> <BR /> location,A,B<BR /> 1,0,1<BR /> 2,1,0<BR /> <BR /> I have tried the following code, which gives me an error:<BR /> <BR /> PROC TRANSPOSE data=before out=after let;<BR /> by location;<BR /> id label;<BR /> RUN;<BR /> <BR /> Any help would be much appreciated. Thanks!<BR /> <BR /> -<BR /> <BR /> Nevermind, this code works fine.<BR /> <BR /> Message was edited by: JeffG Message was edited by: JeffG Thu, 31 Mar 2011 19:25:35 GMT https://communities.sas.com/t5/SAS-Procedures/Problems-with-PROC-Transpose/m-p/41861#M10847 JeffG 2011-03-31T19:25:35Z https://communities.sas.com/t5/SAS-Procedures/Problems-with-PROC-Transpose/m-p/41862#M10848 the codes worked, as per my testing. Thu, 31 Mar 2011 20:25:38 GMT https://communities.sas.com/t5/SAS-Procedures/Problems-with-PROC-Transpose/m-p/41862#M10848 flysnow 2011-03-31T20:25:38Z