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.
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 :
flag = (INDEX(note, "TBI Screening") > 0) ;
This FLAG variable will be 1 or 0.