Date:         Mon, 7 May 2007 11:51:26 -0400
Reply-To:     sanjay sun <sanjaysum@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sanjay sun <sanjaysum@GMAIL.COM>
Subject:      Proc Transpose
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Hi All,

I have a data set with 8 variables - Site, SubjID, LT, Value, unit, Window,
TRT, Group. The group variable has 2 values .I want to transpose the data
set in such a way that I will have all the first 7 variables and two new
variables each from one of the two values of the eighth variable. Can anyone
help me out?

Thanks

Sanjay

Input data set

Site       SubjID      LT      Value      unit       Window
TRT         Group


XXX


YYY



Output data set should look like


Site       SubjID      LT      Value      unit       Window
TRT           XXX              YYY