topic Array subscript out of range in SAS Programming

Array subscript out of range

wj2 — Mon, 25 Nov 2019 19:39:40 GMT

Hello Community,

I am receiving the error message below regarding an array that I am trying to run. I have also provided my code below that. Specifically, I am trying to create a variable (newvar) indicating whether any diagnosis from a set of diagnoses (&painlist) is within 12 months of any diagnosis from a different set (F12.10, F12.20, ...). Can someone please assist me with resolving this issue? Any feedback would be much appreciated!

ERROR: Array subscript out of range at line 196 column 3.
i=100 last.patient_identifier=0 patient_identifier=10 encounter_identifier=224529039 icd=H90.3
diagnosis_date=20JAN2016 diagnosis_type_description=FINAL DIAGNOSIS FIRST.patient_identifier=0
new_var=. m=. n=. dif_day=. yes=. _ERROR_=1 _N_=1

proc sort data=have;
by patient_identifier diagnosis_date;
run;


190  data want;
191   array _c{99} $ 32 _temporary_;
192   array _n{99} _temporary_;
193   do i=1 by 1 until(last.patient_identifier);
194    set have;
195    by patient_identifier;
196    _c{i}=icd;
197    _n{i}=diagnosis_date;
198   end;
199  new_var=0;
200   do m=1 to i-1;
201     do n=m+1 to i;
202      if _c{n} in
202! ('F12.10','F12.120','F12.121','F12.122','F12.129','F12.150','F12.151','F12.159','F12.180','F12.18
202! 8',
203  'F12.19','F12.20','F12.221','F12.222','F12.229','F12.23','F12.250','F12.251','F12.259','F12.288',
203! 'F12.29','F12.90',
204  'F12.920','F12.921','F12.922','F12.929','F12.93','F12.950','F12.951','F12.959','F12.980','F12.988
204! ','F12.99','304.3',
205  '304.30','304.31','304.32','305.2','305.20','305.21','305.22')
206  and _c{m} in (&painlist)
207  then do;
208       dif_day=_n{n}-_n{m};
209       if dif_day le 365 or dif_day ge 365 then do;new_var=1;yes=1;leave;end;
210      end;
211      if yes then leave;
212     end;
213   end;
214   keep patient_identifier new_var;
215   run;

Re: Array subscript out of range

mkeintz — Mon, 25 Nov 2019 19:55:51 GMT

Patient identifier 10 apparently has more than 99 observations in dataset HAVE.

From the ERROR message in the log, you can observe:

the error occurred in line 196, where you have _c{I}=idc;
the list of variable values reports I=100
the list of variable values reports patient_id=10.

Re: Array subscript out of range

wj2 — Tue, 26 Nov 2019 13:17:28 GMT

@mkeintz Ah yes, thank you. Would you be able to suggest how the code might be modified to account for variable numbers of observations for each patient (e.g., patients with >99 observations)?

Re: Array subscript out of range

ballardw — Wed, 27 Nov 2019 18:42:28 GMT

@wj2 wrote:

@mkeintz Ah yes, thank you. Would you be able to suggest how the code might be modified to account for variable numbers of observations for each patient (e.g., patients with >99 observations)?

It may help to describe what you are actually attempting. Possibly a small example data set and the desired output.

You may also want to tell us how the resulting data set is to be used.

You might also tell us if you have access to SAS/IML as the way your are using the nested loops smells sort of like an attempt at matrix use.