https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20541#M4267 Hello Piggy,<BR /> <BR /> This is a solution:<BR /> [pre]data i;<BR /> input Site_ID Meter_Type $;<BR /> datalines;<BR /> 30704 24UC<BR /> 30704 CTRL<BR /> 31032 24UC<BR /> 31032 CTRL<BR /> 31032 CN11<BR /> run;<BR /> proc transpose data=i out=t prefix=Meter_Type;<BR /> var Meter_Type;<BR /> by Site_ID;<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Wed, 02 Mar 2011 20:47:18 GMT SPR 2011-03-02T20:47:18Z https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20539#M4265 Hi,<BR /> <BR /> Can anyone please help me with this?<BR /> I need to transfer the following data <BR /> <BR /> Site_ID Meter_Type<BR /> 30704 24UC<BR /> 30704 CTRL<BR /> 31032 24UC<BR /> 31032 CTRL<BR /> 31032 CN11<BR /> <BR /> to <BR /> <BR /> Site_ID Meter_Type1 Meter_Type2 Meter_Type3<BR /> 30704 24UC CTRL <BR /> 31032 24UC CTRL CN11 Wed, 02 Mar 2011 18:59:19 GMT https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20539#M4265 piggy 2011-03-02T18:59:19Z https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20540#M4266 The procedure that you are looking for is called PROC TRANSPOSE. There are lots of options, so you should read the documentation. EGuide has an easy point-n-click interface that generates the code that you could later use inline. Wed, 02 Mar 2011 19:03:08 GMT https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20540#M4266 Doc_Duke 2011-03-02T19:03:08Z https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20541#M4267 Hello Piggy,<BR /> <BR /> This is a solution:<BR /> [pre]data i;<BR /> input Site_ID Meter_Type $;<BR /> datalines;<BR /> 30704 24UC<BR /> 30704 CTRL<BR /> 31032 24UC<BR /> 31032 CTRL<BR /> 31032 CN11<BR /> run;<BR /> proc transpose data=i out=t prefix=Meter_Type;<BR /> var Meter_Type;<BR /> by Site_ID;<BR /> run;<BR /> [/pre]<BR /> Sincerely,<BR /> SPR Wed, 02 Mar 2011 20:47:18 GMT https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20541#M4267 SPR 2011-03-02T20:47:18Z https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20542#M4268 Thanks guys for your help, and my problem has been solved now<BR /> Another statment to learn. Thu, 03 Mar 2011 18:52:47 GMT https://communities.sas.com/t5/SAS-Procedures/Help-Please/m-p/20542#M4268 piggy 2011-03-03T18:52:47Z