https://communities.sas.com/t5/SAS-Procedures/proc-transpose/m-p/66657#M19043 Yes, PROC TRANSPOSE is the ticket! And it's well documented both in online HELP and at the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website, if you would consider these sources for gaining knowledge from an uber reference source.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <BR /> Google advanced search argument, this topic/post:<BR /> <BR /> proc transpose site:sas.com Wed, 10 Mar 2010 18:07:40 GMT sbb 2010-03-10T18:07:40Z https://communities.sas.com/t5/SAS-Procedures/proc-transpose/m-p/66656#M19042 I have three variables (group, year, rate):<BR /> group year rate<BR /> corp 2009 1<BR /> corp 2010 2<BR /> csbu 2009 3<BR /> csbu 2010 2<BR /> ecs 2009 1<BR /> ecs 2010 4<BR /> <BR /> How do I convert the above data to this:<BR /> group 2009 2010<BR /> corp 1 2<BR /> csbu 3 2<BR /> ecs 1 4 Wed, 10 Mar 2010 17:32:52 GMT https://communities.sas.com/t5/SAS-Procedures/proc-transpose/m-p/66656#M19042 deleted_user 2010-03-10T17:32:52Z https://communities.sas.com/t5/SAS-Procedures/proc-transpose/m-p/66657#M19043 Yes, PROC TRANSPOSE is the ticket! And it's well documented both in online HELP and at the SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website, if you would consider these sources for gaining knowledge from an uber reference source.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> <BR /> Google advanced search argument, this topic/post:<BR /> <BR /> proc transpose site:sas.com Wed, 10 Mar 2010 18:07:40 GMT https://communities.sas.com/t5/SAS-Procedures/proc-transpose/m-p/66657#M19043 sbb 2010-03-10T18:07:40Z