Hi ,
I have to search the variable a in variable b
Example variable a variable b
"North Carolina" Wake Forest University Conference Center, 200 North College Street, Charlotte, North Carolina |
Room 113
if yes then create a flag.
Help?
@sdixit please use descriptive titles. BASE SASE is uninformative and will not help future users searching for a similar solution.
As indicated above you can use either
INDEXW or FINDW to find a phrase in another piece of text.
Look at the examples in the documentation:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212235.htm
Is Variable A always a State name? Do you have a requirement to match Variable A = "North Carolina" to NC in variable B?
Or NC in Variable A to "North Carolina" in Variable B?
@sdixit please use descriptive titles. BASE SASE is uninformative and will not help future users searching for a similar solution.
As indicated above you can use either
INDEXW or FINDW to find a phrase in another piece of text.
Look at the examples in the documentation:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000212235.htm
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.