topic Re: Using an array to 'blank out' values that don't meet a certain criteria? in SAS Programming

Using an array to 'blank out' values that don't meet a certain criteria?

vgrywacheski — Fri, 21 Apr 2017 14:39:23 GMT

Hello,

I have 35 variables for 35 possible diagnosis codes a patient can have. I have a list of diagnoses of interest and need to "blank out" diagnoses which are not on the list. The array I've coded doesn't produce an error message, but I noticed in the output that it appears to be blanking out all the diagnoses, including the ones of interest.

Here's an example of the code:

data base1;
set base;
array diag_code diag_code_01 - diag_code_35;
do i = 01 to dim(diag_code);
if substr(diag_code(i),1,4) not in ("T652")

or substr(diag_code(i),1,3) not in ("O46")
then diag_code(i) = ' ';
end;
drop i;
run;

Any suggestions for how to fix this?

Thanks so much for your advice!

Re: Using an array to 'blank out' values that don't meet a certain criteria?

Reeza — Fri, 21 Apr 2017 14:44:10 GMT

I think you need AND rather than OR in your condition.

Re: Using an array to 'blank out' values that don't meet a certain criteria?

Astounding — Fri, 21 Apr 2017 15:55:30 GMT

Yes, changing AND to OR would work. This simplification should also work:

if diag_code(i) not in : ('T652', 'O46') then diag_code(i) = ' ';

Remember then colon !