Date:         Fri, 1 Aug 2003 16:10:03 -0400
Reply-To:     Robert Abelson <rabelson@KAI-RESEARCH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Robert Abelson <rabelson@KAI-RESEARCH.COM>
Subject:      Re: Why is the value of do variable not being restricted?
Comments: To: ma015 b8234 <ma015b8234@BLUEYONDER.CO.UK>
Content-Type: text/plain

I spoke too soon, as Master Ian has kindly let me know. It seems that I
should provide a little more info. Because LAST.SAP_ID in the first
observation is 0, the stopping condition for the Do Loop will never be true,
and the subscript out of range error is the result.

Bob Abelson
KAI Research, Inc.
6001 Montrose Rd.
Suite 920
Rockville, MD 20852
T: 301-770-2730
F: 301-770-4183
rabelson@kai-research.com

"If you want to inspire confidence, give plenty of statistics.  It does not
matter that they should be accurate, or even intelligible, as long as there
is enough of them."

-Lewis Carroll


> -----Original Message-----
> From: ma015 b8234 [SMTP:ma015b8234@BLUEYONDER.CO.UK]
> Sent: Friday, August 01, 2003 3:48 PM
> To:   SAS-L@LISTSERV.UGA.EDU
> Subject:      Why is the value of do variable not being restricted?
>
> Dear SAS-L Contributors:
>
> I am running this data step and doing array processing.
> The value of do variable is not being restricted by last.variable;
> Can anyone tell me what is going on here?
> SAS Code
>              Data cr_ass.Comms_unique1;
>              set  cr_ass.Comms_unique;
>         by SAP_ID;
>         Array comm(10) $12 Comm_No1-Comm_No10;
>          Do i=1 by 1 until (last.SAP_ID) ;
>            Comm(i)=Comm_no;
>           end;
>          run;
>          Data
>         SAP_ID   SOURCE_SYS_ID SOURCE_REF_KEY  SOURCE_REF_KEY_TYPE
> COMM_NO
> COMM_NO_TYPE
>         10000306 10000306       12246               CT
> 01494528322    MTEL
>         10000306 10000306       12247               CT
> 01494528322    MCTEL
>         10000327 10000327       12291               CT
> 01271378299    MTEL
>         10000327 10000327       12292               CT
> 01271378299    MCTEL
>         10000831 10000831       19282               CT
> 01823334665    MTEL
>         10000831 10000831       19283               CT
> 01823334665    MCTEL
>
>          Log Message
>          Data cr_ass.Comms_unique1;
>          4    set  cr_ass.Comms_unique;
>          5    by SAP_ID;
>          6    Array comm(10) $12 Comm_No1-Comm_No10;
>          7    Do i=1 by 1 until (last.SAP_ID) ;
>          8    Comm(i)=Comm_no;
>          9    end;
>          10   run;
>
>         ERROR: Array subscript out of range at line 8 column 1.
>         SAP_ID=10000306 SOURCE_SYS_ID=10000306 SOURCE_REF_KEY=12246
> SOURCE_REF_KEY_TYPE=CT
>         COMM_NO=01494528322 COMM_NO_TYPE=MTEL FIRST.SAP_ID=1 LAST.SAP_ID=0
> Comm_No1=01494528322
>         Comm_No2=01494528322 Comm_No3=01494528322 Comm_No4=01494528322
> Comm_No5=01494528322
>         Comm_No6=01494528322 Comm_No7=01494528322 Comm_No8=01494528322
> Comm_No9=01494528322
>        Comm_No10=01494528322 i=11 _ERROR_=1 _N_=1
>        NOTE: The SAS System stopped processing this step because of
> errors.
>        NOTE: There were 2 observations read from the data set
> CR_ASS.COMMS_UNIQUE.
>        WARNING: The data set CR_ASS.COMMS_UNIQUE1 may be incomplete.  When
> this step was stopped there
>          were 0 observations and 17 variables.
>         WARNING: Data set CR_ASS.COMMS_UNIQUE1 was not replaced because
> this
> step was stopped.
>    Thanks in advance for your help
>
>     John