BookmarkSubscribeRSS Feed
WAL83
Obsidian | Level 7
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.
2 REPLIES 2
Olivier
Pyrite | Level 9
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.
WAL83
Obsidian | Level 7
Thanks for the info. I was out of town or would have gotten back sooner.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Health and Life Sciences Learning

 

Need courses to help you with SAS Life Sciences Analytics Framework, SAS Health Cohort Builder, or other topics? Check out the Health and Life Sciences learning path for all of the offerings.

LEARN MORE

Discussion stats
  • 2 replies
  • 898 views
  • 0 likes
  • 2 in conversation