topic Re: susbstrn statement with different lengths variables in SAS Programming

susbstrn statement with different lengths variables

lillymaginta — Sun, 06 May 2018 18:28:24 GMT

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;

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?

Re: susbstrn statement with different lengths variables

novinosrin — Sun, 06 May 2018 19:13:37 GMT

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;

run

Re: susbstrn statement with different lengths variables

Astounding — Sun, 06 May 2018 19:16:30 GMT

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;