topic Re: Substring search in SAS Programming

Substring search

zimcom — Thu, 19 Jul 2018 01:24:26 GMT

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

Re: Substring search

PaigeMiller — Thu, 19 Jul 2018 01:47:16 GMT

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".

Re: Substring search

zimcom — Thu, 19 Jul 2018 01:55:37 GMT

Love SAS Communities!