Date:         Mon, 30 Dec 2002 08:50:19 -0500
Reply-To:     Carol Gosselin <clgossel@GW.FIS.NCSU.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Carol Gosselin <clgossel@GW.FIS.NCSU.EDU>
Subject:      Re: Rotate rows to columns
Content-Type: text/plain; charset=US-ASCII

Look up PROC TRANSPOSE in the online documentation.  It is designed to
do specifically what you are asking here.

Carol L. Gosselin
Applications Analyst Programmer II
University Planning and Analysis
Box 7002, 201 Peele Hall
North Carolina State University
Raleigh, NC 27695-7002
Phone:  919-515-6435
Fax:  919-831-3541
Email:  carol_gosselin@ncsu.edu

>>> Jishnu <jishguha@YAHOO.COM> 12/20/02 10:48PM >>>
Hi All,

Does any one know how to rotate rows to columns

Sample:
0   34   x
0   35   y
0   22   z
1   24   x
1   22   y
1   21   z

I want like
   x   y   z
0  34  35  22
1  24  22  21

what I am achieving right now is
   x    y    z
0  34
0       35
0           22

and so on
Please can one help me.