topic Re: Using substr function in arrays in SAS Health and Life Sciences

Using substr function in arrays

deleted_user — Fri, 26 Oct 2007 09:25:48 GMT

Hi

I am new to SAS, so please bear with me. I am trying to use an array to split a 240 character field of death codes into 48 new variables, each with a width of 5 characters .... with a starting position that moves from 1, 6, 11, 16, 21 etc. Alas, my syntax below keeps succumbing to the error message "The array subscript is out of range":

data b;
set a;
array split(48) $ entity1 - entity48;
do i = 1-48;
j = ((i-1)*5)+1;
split(i) = substr(entity_axis_data,j,5);
end;
run;

Any pearls of wisdom would be appreciated immensely.

Janine

Re: Using substr function in arrays

advoss — Fri, 26 Oct 2007 13:45:46 GMT

Try this:



data b;

  set a;

  length entity1 - entity48 $5;

  array split(48) entity1 - entity48;

  do i = 1 to 48;

    j = ((i-1)*5)+1;

   split(i) = substr(entity_axis_data,j,5);

  end;

run;

Re: Using substr function in arrays

deleted_user — Tue, 30 Oct 2007 03:09:42 GMT

Ripper! It worked a treat. Many thanks Advoss.