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: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 907 views
  • 0 likes
  • 2 in conversation