Date: Thu, 13 Jul 2000 09:39:09 -0700
Reply-To: "William W. Viergever" <wwvierg@IBM.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "William W. Viergever" <wwvierg@IBM.NET>
Subject: Re: Maximum number of vars in a data set V8.0
In-Reply-To: <8F6F9FED4dmclerrafhcrcorg@140.107.92.24>
Content-Type: multipart/alternative;
Hi Dale:
Not sure how *your* code shows that you can have > 322676 vars in the PDV, but you're right anyway! <g>:
>NOTE: Copyright (c) 1999 by SAS Institute Inc., Cary, NC, USA.
>NOTE: SAS (r) Proprietary Software Version 8 (TS M0)
> Licensed to VIERGEVER & ASSOCIATES, Site 0019446002.
>NOTE: This session is executing on the WIN_PRO platform.
>
>
>
>NOTE: SAS initialization used:
> real time 5.81 seconds
> cpu time 0.68 seconds
>
>1 data a;
>2 length c1-c32767 $1;
>3 retain _character_ ' ';
>4 stop;
>5 run;
>
>NOTE: The data set WORK.A has 0 observations and 32767 variables.
>NOTE: DATA statement used:
> real time 1.22 seconds
> cpu time 1.02 seconds
>
>
>6
>7 data b;
>8 length c1-c32768 $1;
>9 retain _character_ ' ';
>10 stop;
>11 run;
>
>ERROR: Too many variables defined for file WORK.B. This file may not have more than 32767
> variables.
>NOTE: The SAS System stopped processing this step because of errors.
>WARNING: The data set WORK.B was only partially opened and will not be saved.
>NOTE: DATA statement used:
> real time 0.86 seconds
> cpu time 0.82 seconds
>
>
>12
>13 data _null_;
>14 length c1-c32768 $1;
>15 retain _character_ ' ';
>16 stop;
>17 run;
>
>NOTE: DATA statement used:
> real time 0.55 seconds
> cpu time 0.48 seconds
At 09:35 PM 07/12/2000, Dale McLerran wrote:
>The number of variables in an output dataset (PC SAS V8.0) is just
>as Peter has shown for os390 V8.0. Note, however, that we can have
>more than 32767 variables in the PDV. It is only the output dataset
>which restricts us to 32K-1. (Not to say that there is not some
>restriction on the number of variables in the PDV as well.) The
>limits on the output dataset are the same as those from V6.12.
>
>1 data;
>2 length c1-c32767 $1;
>3 retain _character_ ' ';
>4 stop;
>5 run;
>
>NOTE: The data set WORK.DATA1 has 0 observations and 32767 variables.
>
>6
>7
>8 data;
>9 length c1-c32768 $1;
>10 retain _character_ ' ';
>11 stop;
>12 run;
>
>ERROR: Too many variables defined for file WORK.DATA2. This file may not have
>more than 32767 variables.
>NOTE: The SAS System stopped processing this step because of errors.
>
>13
>14
>15 data;
>16 length c1-c32767 $1;
>17 retain _character_ ' ';
>18 array test {500} _temporary_;
>19 a = 9;
>20 stop;
>21 drop a;
>22 run;
>
>NOTE: The data set WORK.DATA4 has 0 observations and 32767 variables.
>
>
>Dale
>
>--------------------------------------
>Dale McLerran
>Fred Hutchinson Cancer Research Center
>Seattle, WA 98109
>mailto:dmclerra@fhcrc.org
>ph: (206) 667-2926
>fax: (206) 667-5977
>--------------------------------------
>
>
>peter.crawford@DB.COM (Peter Crawford) wrote in <OF748AA2B5.8E501C48-
>ON4125691A.007645E0@esb.eur.deuba.com>:
>
>>There may be some options to increase what is available, but
>>on this os390 v8.0 the max seems to be 32K -1 (i.e. 32767 )
>>NOTE: AUTOEXEC processing completed.
>>
>>1 data;
>>2 length c1-c32767 $1;
>>3 retain _character_ ' ';
>>4 stop;
>>5 run;
>>
>>NOTE: The data set WORK.DATA1 has 0 observations and 32767 variables
>>NOTE: The DATA statement used 2.39 CPU seconds and 20687K.
>>
>>6 data;
>>7 length c1-c32768 $1;
>>8 retain _character_ ' ';
>>9 stop;
>>10 run;
>>
>>ERROR: Too many variables defined for file WORK.DATA2. This file
>> may not have more than 32767 variables.
>>NOTE: The SAS System stopped processing this step because of errors.
>>WARNING: The data set WORK.DATA2 was only partially opened and
>> will not be saved.
>>NOTE: The DATA statement used 2.08 CPU seconds and 20687K.
>>
>>
>>Datum: 12.07.2000 21:50
>>An: SAS-L@listserv.uga.edu
>>
>>
>>
>>
>>Antwort an: npaszty@organic.com
>>
>>Betreff: Maximum number of vars in a data set V8.0
>>Nachrichtentext:
>>
>>
>>Hello.
>>
>>I'm tired of looking through the documentation someone must know what the
>>maximum number of vars is in a SAS data set under PC V8.0
>>
>>Ugh,
>>
>>Nick
>>
----------------------------------------------------------------------------
William W. Viergever Voice : (916) 483-8398
Viergever & Associates Fax : (916) 486-1488
A SAS Institute Quality Partner (USA) E-mail : wwvierg@ibm.net
Sacramento, CA 95825
"Once I wanted to become an atheist, but I gave up - they have no holiday."
- Henny Youngman
"God gives every bird his worm, but he does not throw it into the nest."
- Swedish proverb
----------------------------------------------------------------------------
[text/html]
| 
