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?
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
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
> Thanks a lot in advance.
> Best regards,