Date:         Tue, 12 Dec 2006 17:17:10 -0800
Reply-To:     Wei ZOU <wzou@UCDAVIS.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Wei ZOU <wzou@UCDAVIS.EDU>
Organization: University of California, Davis
Subject:      Error message from SAS. Re: Transpose columns to rows in SAS?
Comments: To: sas-l@uga.edu
In-Reply-To:  <457E0615.1050406@ucdavis.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

> ERROR: Too many variables defined for file WORK.TRAN0.  This file may not have more than 32767
>        variables.

It seems that the limitation is 32767 variables per table. Thanks.



Wei ZOU wrote:
> Hello, all:
>
> I am trying to change my data columns to data rows, i.e., variables <->
> cases. In Excel it is called "transpose". Since My data set is big,
> Excel cannot process it. Could you please tell me if I can do this using
> SAS Transpose in Analyst or code?
>
> An illustration of my original data set:
> id time height
> 1  100  1011
> 2  200  111
> 3  300  4222
> 4  400  3502
> 5  500  100
> 6  600  300
>
> I want to transpose it to
>        var1 var2 var3 var4 var5 var6
> time
> height
>
> Thanks a lot in advance.
>
>
> Best regards,
>
> Wei