Search variable for specified text and return flag

Reply
Contributor
Posts: 41

Search variable for specified text and return flag

Is there a way in SAS to search for specific text in a variable and if found set a flag to 1. I am currently trying to determine if records in my dataset contain the text "TBI Screening". I can do this in MS Access with criteria [Like "*TBI Screening*"] and it works. Just wondering if you can do similar in SAS. The variable used in the search is called note and can contain up to 32000+ characters. Thanks.
Super Contributor
Posts: 260

Re: Search variable for specified text and return flag

Check the INDEX, INDEXW and (more flexible but more complicated to write) PRXMATCH functions.
They all return a positive number when the string is found, else a zero. So you can build :
[pre]
flag = (INDEX(note, "TBI Screening") > 0) ;
[/pre]
This FLAG variable will be 1 or 0.
Contributor
Posts: 41

Re: Search variable for specified text and return flag

Thanks for the info. I was out of town or would have gotten back sooner.
Ask a Question
Discussion stats
  • 2 replies
  • 323 views
  • 0 likes
  • 2 in conversation