https://communities.sas.com/t5/SAS-Programming/Transforming-a-SAS-data-set/m-p/28249#M5202 I need to convert a SAS-data set with two sort keys to a new set where key 1 define rows and key 2 define columns in the new set as exemplified below (as can be done with the pivot function in Excel)<BR /> <BR /> Input:<BR /> Key1 Key2 Data<BR /> T1 AA 23<BR /> T2 AA 24<BR /> T3 AA 21<BR /> T1 BB 19<BR /> T2 BB 25<BR /> T1 CC 43<BR /> T3 CC 43<BR /> <BR /> needed output:<BR /> <BR /> Key1 AA BB CC<BR /> T1 23 19 43<BR /> T2 24 25 <BR /> T3 21 43 Thu, 04 Nov 2010 10:59:12 GMT StaffanK 2010-11-04T10:59:12Z https://communities.sas.com/t5/SAS-Programming/Transforming-a-SAS-data-set/m-p/28249#M5202 I need to convert a SAS-data set with two sort keys to a new set where key 1 define rows and key 2 define columns in the new set as exemplified below (as can be done with the pivot function in Excel)<BR /> <BR /> Input:<BR /> Key1 Key2 Data<BR /> T1 AA 23<BR /> T2 AA 24<BR /> T3 AA 21<BR /> T1 BB 19<BR /> T2 BB 25<BR /> T1 CC 43<BR /> T3 CC 43<BR /> <BR /> needed output:<BR /> <BR /> Key1 AA BB CC<BR /> T1 23 19 43<BR /> T2 24 25 <BR /> T3 21 43 Thu, 04 Nov 2010 10:59:12 GMT https://communities.sas.com/t5/SAS-Programming/Transforming-a-SAS-data-set/m-p/28249#M5202 StaffanK 2010-11-04T10:59:12Z https://communities.sas.com/t5/SAS-Programming/Transforming-a-SAS-data-set/m-p/28250#M5203 Check PROC TRANSPOSE in the SAS DOC. Also, there are SAS support website technical / conference 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 Thu, 04 Nov 2010 11:08:32 GMT https://communities.sas.com/t5/SAS-Programming/Transforming-a-SAS-data-set/m-p/28250#M5203 sbb 2010-11-04T11:08:32Z