topic Re: find function in SAS Enterprise Guide

find function

avatar — Thu, 13 Nov 2014 19:03:07 GMT

Hi,

I am interested to delete some drugs in a string (occuring in the middle of the string that has drug name) . I used find function like below. it works however I have a long list of

if find (therapy, 'ACTEMRA') then delete;

if find (therapy, 'AVASTIN') then delete;

if find (therapy, 'AVEED') then delete;

if find (therapy, 'BOTOX') then delete;

if find (therapy, 'DACOGEN') then delete;

Is it possible to combine all and more drugs in one statement?

Please advise.

Thanks

Re: find function

stat_sas — Thu, 13 Nov 2014 19:37:07 GMT

Something like this may help.

data want;

set have;

array del(5) ACTEMRA AVASTIN AVEED BOTOX DACOGEN;

counter=0

do i=1 to dim(del);

if find(therapy,vname(del(i)), 'i') then counter+1;

end;

if counter>=1 then delete;

run;

Re: find function

Haikuo — Thu, 13 Nov 2014 19:58:01 GMT

If you don't mind some Perl Regular Expression:

data want;

set have;

if not prxmatch('/(ACTEMRA|AVASTIN|AVEED|BOTOX|DACOGEN)/', var);

run;

Haikuo

Re: find function

slchen — Thu, 13 Nov 2014 20:06:29 GMT

data want;

set have(where=(therapy not in ('ACTEMRA' 'AVASTIN' 'AVEED' 'BOTOX' 'DACOGEN')));

run;

Re: find function

ballardw — Thu, 13 Nov 2014 20:58:02 GMT

The IN will not work if the variable value actually is "AVASTIN 10MG" or similar additional information.

Re: find function

avatar — Thu, 13 Nov 2014 21:27:24 GMT

That is exactly the problem
I guess I may have to stick with Find function.

Thanks for all responses

Re: find function

ballardw — Thu, 13 Nov 2014 21:41:52 GMT

A modification of

data want;

set have;

array del{5} $ _temporary_ ('ACTEMRA','AVASTIN','AVEED','BOTOX','DACOGEN'); /* add the values and update the number in the array reference

counter=0;

do i=1 to dim(del);

if find(therapy,del(i)) then counter+1;

end;

if counter>=1 then delete;

drop i counter;

run;