Date: Sun, 15 Feb 2004 11:14:26 -0600
Reply-To: pudding man <pudding_man@MAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: pudding man <pudding_man@MAIL.COM>
Subject: Re: [9.1] Maximum number of variables, etc
Content-Type: text/plain; charset="iso-8859-1"
>I think it would be a good thing to preface posting subjects
>with a [9.1] to indicate the post has some relation to 9.1
Yes, I think this would be a good idea. Some sas-l
folks won't be running 9.1 for another year or longer.
Others need to know certain things ASAP. I do not expect
to be running it anytime soon ... but it piques my po'
curiosity.
>Using 9.1, I was able to a make data set of 1 row and
>1,000,000 columns in about 30 seconds. Nice... and
>dangerous.
Aha! They (at SI) have been tinkering. Indeed, this increases
the potential for a certain class of foot wounds. <g>
If I run, on W2kP V8, something like:
17 options fullstimer;
18 data v10k;
19 array x(10000);
20 run;
NOTE: The data set WORK.V10K has 1 observations and 10000 variables.
NOTE: DATA statement used:
real time 0.23 seconds
user cpu time 0.20 seconds
system cpu time 0.02 seconds
Memory 2060k
21
22 data v20k;
23 array x(20000);
24 run;
NOTE: The data set WORK.V20K has 1 observations and 20000 variables.
NOTE: DATA statement used:
real time 0.50 seconds
user cpu time 0.45 seconds
system cpu time 0.02 seconds
Memory 4024k
and do the arithmetic ((4024 - 2060) / (20 - 10)), it *appears*
that SAS gobbles about 196 bytes of memory for every var added to a
SAS dataset. It is somewhat less on z/OS and generally platform
dependent.
Do you get something comparable with your (Windozy ?) 9.1? Or
have they worked other (desirable or undesirable) Wizardries??
Salut,
Puddin'
*******************************************************
***** Puddin' Man **** Pudding_Man-at-mail.com ********
*******************************************************;
Pease pudding hot,
Pease pudding cold,
Pease pudding in the pot
Nine days old.
----- Original Message -----
From: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Date: Sun, 15 Feb 2004 09:49:50 -0500
To: SAS-L@LISTSERV.UGA.EDU
Subject: [9.1] Maximum number of variables
9.1 has started shipping and some of use may already have it. I think it
would be a good thing to preface posting subjects with a [9.1] to indicate
the post has some relation to 9.1
Here is something I found in the 9.1 help
"
Note: Starting with SAS 9.1, the maximum number of variables can be
greater than 32,767. The maximum number is dependent on your environment and
the file's attributes.
"
Using 9.1, I was able to a make data set of 1 row and 1,000,000 columns in
about 30 seconds. Nice... and dangerous.
--
Richard A. DeVenezia
http://www.devenezia.com
--
___________________________________________________________
Sign-up for Ads Free at Mail.com
http://promo.mail.com/adsfreejump.htm
