correct city names

Reply
Regular Contributor
Posts: 161

correct city names

Dear All:

Could you please tell me whether there is a function in SAS that can me correct and identify U.S. city and state names?  For example, the following is manually entered.  Thus, it contains data entry errors.  Could you please tell me the best way to clean these city names within SAS.  Thank you!

MIMNEAPOLIS

MN

MIDWAY

TN

BOULDER(BROOMFIELD

CO

CHICACO

IL

ETIWANDA

CA

MIDVALE

UT

MICHIGAN CITY

IN

EMERYVILLE

CA

Respected Advisor
Posts: 3,901

Re: correct city names

If the Data Quality Server is licensed at your site then you could use function DQSTANDARDIZE()

SAS(R) 9.3 Data Quality Server Reference

Else: It's quite a bit of coding and if you search this forum then you'll find multiple discussions around data cleansing and standardisation.

Ask a Question
Discussion stats
  • 1 reply
  • 205 views
  • 3 likes
  • 2 in conversation