susbstrn statement with different lengths variables

[lillymaginta]

Hi all,

I have the following statement:

data a (drop=i); set b; array x{*} dx:; r=1=0;

do i=1 to dim(x); if susbtrn(x{i},1,3) in ('210','220') then do; r=1;

leave;

end;

end;

run;

my question if I want to include another entry with a length of 4 meaning if susbtrn= '210', '220', '2320', how can I adjust the above statement to account for different the lengths?

[novinosrin · Accepted solution]

data a (drop=i); set b; array x{*} dx:; r=1=0;

do i=1 to dim(x);
if susbtrn(x{i},1,3) in ('210','220')
or susbtrn(x{i},1,4) in ( '2320')
then do; r=1;

leave;

end;

end;

run

[Astounding]

I'm not sure you have the spelling right, but here's a variation that works for character strings:

if x{i} in : ('210','220','2299') then do;