LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (December 2009, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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>
Subject:      Transpose function?
Comments: To:
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

Back to: Top of message | Previous page | Main SAS-L page