Date: Sat, 21 May 2011 21:17:57 -0400
Reply-To: Nat Wooding <nathani@VERIZON.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nat Wooding <nathani@VERIZON.NET>
Subject: Re: Slightly OT, But Still SAS Related
Content-Type: text/plain; charset="US-ASCII"
This pretty well jives with my empirical findings. The major problem that I
recently had was that SASHELP.ZIP only recognized one name per zip code/post
As for names like River Bank, I have found it interesting that Google Maps
will often show place names in a metropolitan area (meaning, for me,
Richmond, VA) and some of these names are nothing that I have heard after
living in the area for nearly 40 years.
From: Jack Hamilton [mailto:firstname.lastname@example.org]
Sent: Saturday, May 21, 2011 1:53 PM
To: Nat Wooding
Subject: Re: [SAS-L] Slightly OT, But Still SAS Related
Some post offices have multiple names, all of which are legitimate. For
example, my old PO Box near my former employer was in 95605. That's in the
city limits of West Sacramento, and shows up as such in some databases, but
I always used Broderick as the city name to reduce the chances of my mail
going to one of the other West Sacramento post offices. That ZIP code
included the post office names West Sacramento, Broderick, and Bryte. The
USPS page says that River Bank is an additional but unacceptable name,
whatever that means.
On May 21, 2011, at 5:31 AM, Nat Wooding wrote:
> Recently, I needed to match place names with zip codes and discovered that
> the names given in SASHELP.Zipcodes did not always pair up with city names
> given by the people in my list. I do not immediately recall specific
> examples of communities but I do remember that some military bases had
> own zip codes while others did not. For the cities, the city given in the
> address was, in the zipcode file, rolled into the name of a larger
> metropolitan area.
> Someone may have already said this but SASHELP.Zip includes lat/long as
> as county name plus some other information such as area codes.
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
> Sent: Friday, May 20, 2011 3:42 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Slightly OT, But Still SAS Related
> Dear SAS-L-ers,
> The staff on one of our projects is looking for a table that correlates
> counties in the great state of Massachusetts with Zip codes. That data
> be used in SAS programs that crunch medical records and correlate zip
> with Massachusetts counties. Does anybody know of such an electronic
> of information? Anybody form the Bay State that can chime in on this?
> All, best of luck in all your SAS endeavors!
> I hope that this suggestion proves helpful now, and in the future!
> Of course, all of these opinions and insights are my own, and do not
> those of my organization or my associates. All SAS code and/or
> specified in this posting are for illustrative purposes only and no
> is stated or implied as to their accuracy or applicability. People
> to use information in this posting do so at their own risk.
> Michael A. Raithel
> "The man who wrote the book on performance"
> E-mail: MichaelRaithel@westat.com<mailto:MichaelRaithel@westat.com>
> Author: Tuning SAS Applications in the MVS Environment
> Author: Tuning SAS Applications in the OS/390 and z/OS Environments,
> Author: The Complete Guide to SAS Indexes
> Sometimes the road less traveled is less traveled for a reason. - Jerry