ma015 b8234 <ma015b8234@BLUEYONDER.CO.UK> wrote:
> 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?
> 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) ;
Hmmm. You have a SET and a BY statement, but your array has
no other inputs. It looks you are (accidentally) writing
the same value into every element of the array until you
overflow the boundary. This is because you are *not* reading
any new records in while you are in the DO loop.
At a guess (a wild guess at that) you wanted to perform a DOW-loop
and accidentally left the code in the form of the traditional SAS
implicit loop instead. Perhaps you want something more like:
array comm(10) $12 Comm_No1-Comm_No10;
do i=1 by 1 until (last.SAP_ID);
If all you want is to turn your comm_no values into a row
of comm_noX values, then you could do this in PROC TRANSPOSE
David Cassell, CSC
Senior computing specialist