Search an address variable for a specific value/variable value

[sdixit]

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?

[Kurt_Bremser]

Use the index() function.

[ballardw]

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?

[Reeza · Accepted solution]

@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