topic Search an address variable for a specific value/variable value in SAS Programming

Search an address variable for a specific value/variable value

sdixit — Thu, 11 May 2017 19:49:53 GMT

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 — Thu, 11 May 2017 17:42:14 GMT

Use the index() function.

ballardw — Thu, 11 May 2017 17:47:29 GMT

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 — Thu, 11 May 2017 20:03:04 GMT

@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: