Date:         Thu, 17 Dec 2009 11:06:40 -0800
Reply-To:     Sdlentertd <sdlentertd@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sdlentertd <sdlentertd@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Transpose function?
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

I have a SAS dataset with these columns:
loc1 member1 rx1 date1                loc2 member2 rx2     date2
NY   M025     0545   01SEP2009    MN    J545      0689    05SEP2009
TN   N123      0145   02SEP2009     AR    J654      1234  06SEP2009


I need to put all those columns into rows and the main columns will be
Loc     Member    rx     date
NY     M025        0545   01SEP2009
TN     J545      0689       05SEP2009
MN    N123       0145     02SEP2009
AR    J654      1234      06SEP2009

I am looking to transpose those columns into rows; and the values
would match appropriate columns

There are like 50 original columns and all of them have 1 through 10
at the end of the variable name  .
Thank you