Date:         Wed, 10 Jan 2007 22:52:39 -0800
Reply-To:     David L Cassell <davidlcassell@MSN.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         David L Cassell <davidlcassell@MSN.COM>
Subject:      Re: Help for proc transpose
In-Reply-To:  <200701092051.l09JFGrU002006@mailgw.cc.uga.edu>
Content-Type: text/plain; format=flowed

program.sas@GMAIL.COM wrote:
>
>Hi All
>
>I had a stupid question about proc transpose
>
>Here is my data
>
>1 1 a j
>1 2 b k
>1 3 c l
>2 1 d m
>2 2 e n
>2 3 f o
>3 1 g p
>3 2 h q
>3 3 i r
>
>I want to transpose the dataset like this:
>
>------------------
>1 a j d m g p
>2 b k e n h q
>3 c l f o i r
>
>How can I do that? Thanks

I see that people have told you how to do this.

I would like to suggest that you not do it at all.

You are turning what looks like a workable data structure into
a major headache in the making.  Your transposed form will
be harder to work with, harder to analyze, harder to handle
in database managment issues, etc.

If you need this as output (e.g., a display or an Excel file)
then there may be better options.  Otherwise, I would suggest
that you avoid going this route.

HTH,
David
--
David L. Cassell
mathematical statistician
Design Pathways
3115 NW Norwood Pl.
Corvallis OR 97330

_________________________________________________________________
Find sales, coupons, and free shipping, all in one place!  MSN Shopping
Sales & Deals
http://shopping.msn.com/content/shp/?ctid=198,ptnrid=176,ptnrdata=200639