Desktop productivity for business analysts and programmers

Zipcode Reduction

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 13
Accepted Solution

Zipcode Reduction

Hi everyone,

    I have a dataset which has 17854 distinct levels of zipcodes spread across USA . Is there any function in SAS or any method using which I can reduce the number of levels ? I need to reduce it to less than 500 distinct levels.

Thanks and Regards,

Minal


Accepted Solutions
Solution
‎04-12-2014 04:14 AM
Respected Advisor
Posts: 3,822

Re: Zipcode Reduction

There is a whole category in the SAS docu for Zip code related functions.

SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition

You could use a function which returns the state based on a zip code. That would allow you to group them.

View solution in original post


All Replies
Solution
‎04-12-2014 04:14 AM
Respected Advisor
Posts: 3,822

Re: Zipcode Reduction

There is a whole category in the SAS docu for Zip code related functions.

SAS(R) 9.4 Functions and CALL Routines: Reference, Second Edition

You could use a function which returns the state based on a zip code. That would allow you to group them.

Esteemed Advisor
Posts: 7,280

Re: Zipcode Reduction

You could use the scf groupings (see: USPS.com® - Learn About Integrating with USPS APIs )

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 231 views
  • 3 likes
  • 3 in conversation