DATA Step, Macro, Functions and more

Capture city and country from address String

Reply
Super Contributor
Posts: 673

Capture city and country from address String

There are four columns for address which contain street address, city and country.

The issue is they are not structured, i.e addr2 colunmn may contain city name for some records and addr3 may contain city name.

Now I would like to contacatenate all address fields to one string and get the city and country names from it.

How do we achieve that?Is there any SAS Uitlity that has list of all cities and countries in the world?

PROC Star
Posts: 7,468

Re: Capture city and country from address String

There isn't such a utility that I'm aware of.  However, if you post a subset of your file, someone might be able to suggest an alternative way of doing what you want.

Ask a Question
Discussion stats
  • 1 reply
  • 187 views
  • 0 likes
  • 2 in conversation