topic Transposing Numbers in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29451#M6923 I have a large dataset similar in set up to that below:<BR /> <BR /> account date value<BR /> 1 month1 10<BR /> 1 month2 25<BR /> 1 month3 19<BR /> 2 month1 8<BR /> 2 month2 0<BR /> 2 month3 18<BR /> 3 month1 23<BR /> 3 month2 9<BR /> 3 month3 27<BR /> <BR /> What I want to do is to collapse the account to 1 row per account and create a new dataset to look like this:<BR /> account month1 month2 month3<BR /> 1 10 25 19<BR /> 2 8 0 18<BR /> 3 23 9 27<BR /> <BR /> Do I need to use an array for this, or would transpose work in some way?<BR /> <BR /> Thanks for any help. Message was edited by: uksusu Fri, 05 Nov 2010 17:16:39 GMT uksusu 2010-11-05T17:16:39Z Transposing Numbers https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29451#M6923 I have a large dataset similar in set up to that below:<BR /> <BR /> account date value<BR /> 1 month1 10<BR /> 1 month2 25<BR /> 1 month3 19<BR /> 2 month1 8<BR /> 2 month2 0<BR /> 2 month3 18<BR /> 3 month1 23<BR /> 3 month2 9<BR /> 3 month3 27<BR /> <BR /> What I want to do is to collapse the account to 1 row per account and create a new dataset to look like this:<BR /> account month1 month2 month3<BR /> 1 10 25 19<BR /> 2 8 0 18<BR /> 3 23 9 27<BR /> <BR /> Do I need to use an array for this, or would transpose work in some way?<BR /> <BR /> Thanks for any help. Message was edited by: uksusu Fri, 05 Nov 2010 17:16:39 GMT https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29451#M6923 uksusu 2010-11-05T17:16:39Z Re: Transposing Numbers https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29452#M6924 Check PROC TRANSPOSE in the SAS DOC, the forum archives, or search the SAS support website for technical / conference reference material on the topic.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Suggested Google advanced search argument, this topic / post:<BR /> <BR /> proc transpose site:sas.com Fri, 05 Nov 2010 17:23:50 GMT https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29452#M6924 sbb 2010-11-05T17:23:50Z Re: Transposing Numbers https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29453#M6925 Thanks Scott<BR /> <BR /> It worked a treat. Mon, 08 Nov 2010 09:41:27 GMT https://communities.sas.com/t5/SAS-Procedures/Transposing-Numbers/m-p/29453#M6925 uksusu 2010-11-08T09:41:27Z