Date: Sat, 10 May 2003 14:53:57 +0100
Reply-To: John Whittington <John.W@MEDISCIENCE.CO.UK>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: John Whittington <John.W@MEDISCIENCE.CO.UK>
Subject: Re: maximum number of variables in SAS
In-Reply-To: <E19EMdA-00049Y-00@coumxnn02.netbenefit.co.uk>
Content-Type: text/plain; charset="us-ascii"; format=flowed
At 22:10 09/05/03 -0700, Dale McLerran wrote:
>Indeed, I have employed datasteps in which I use more than 32K
>variables. However, I have some applications in which I need
>to transpose a dataset which has tens of thousands of rows.
>The rows of the original dataset are effectively candidate
>variables for a machine learning problem.
Right. You would, indeed, have a problem (pre-v9) if you actually needed
to create a transposed dataset (and PROC TRANSPOSE gives you no option
other than to create a transposed dataset). However, if it were adequate
for you to process 'transposed' data within a DATA step, then you could
obviously emulate the transposition within that DATA step simply by reading
the entire source dataset into a temporary array (if you had enough resources).
>As noted by Kevin Delaney
>and Ed Heaton, V9 on a Windows platform does not deliver the
>ability to write a dataset with more than 32K variables. Until
>two or three months ago, I would never have thought that I
>would need the ability to write a dataset with so many variables.
As you will have seen, Jack has posted something which looks as if it may
achieve what you want/need in v9.
Kind Regards
John
----------------------------------------------------------------
Dr John Whittington, Voice: +44 (0) 1296 730225
Mediscience Services Fax: +44 (0) 1296 738893
Twyford Manor, Twyford, E-mail: John.W@mediscience.co.uk
Buckingham MK18 4EL, UK mediscience@compuserve.com
----------------------------------------------------------------
| 
