Substring search

[zimcom]

Dear all,

I need to go through a column and do substring search and only inlude the entry containing "within 10 minutes", "within 15 minutes", "minutes" "within" and "infusion", is this doable in SAS?

Thank you

zimcom 

[PaigeMiller · Accepted solution]

Yes, SAS can do this. Something like this, where text is the variable in your data set that you want to search.

Data want;
    set have;
    if find(text,'within 10 minutes')>0 or find(text,'infusion')>0 or ... 
         /* you type the rest */ then output;
run;

Also, did you really mean to use the word "and"? The code I gave assumes you really meant "or". 

[zimcom]

Love SAS Communities!