Date: Tue, 28 Jul 2009 09:11:56 -0500
Reply-To: AnnHett <annhett@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: AnnHett <annhett@GMAIL.COM>
Subject: Re: County Validation
Content-Type: text/plain; charset=ISO-8859-1
I was out of the office yesterday, but I'm looking forward to looking at all
of these ideas.
On Mon, Jul 27, 2009 at 9:50 AM, Mike Zdeb <firstname.lastname@example.org> wrote:
> hi ... if anyone is interested in a proposed solution to this question,
> take a look at ...
> ps if you do look, any comments/suggestions are welcome
> Mike Zdeb
> U@Albany School of Public Health
> One University Place
> Rensselaer, New York 12144-3456
> P/518-402-6479 F/630-604-1475
> > All,
> > We have addresses in a database. For IL addresses we need county, which
> > often missing.
> > I'm having trouble finding a source for a county lookup. The problem is
> > that some zip codes span multiple counties.
> > Everything I've looked at seems to be use the "most prevalent" county for
> > the 5-digit ZIP code. SASHELP.ZIPCODE seems to also work this way.
> > The USPS webtools do not include county validation.
> > Does anyone have any low-cost ideas?
> > Thanks,
> > ann