Date: Sat, 21 May 2011 10:52:56 -0700
Reply-To: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject: Re: Slightly OT, But Still SAS Related
Content-Type: text/plain; charset=us-ascii
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 their
> 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 well
> 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 Michael
> 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 the
> counties in the great state of Massachusetts with Zip codes. That data will
> be used in SAS programs that crunch medical records and correlate zip codes
> with Massachusetts counties. Does anybody know of such an electronic source
> 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 reflect
> those of my organization or my associates. All SAS code and/or methodologies
> specified in this posting are for illustrative purposes only and no warranty
> is stated or implied as to their accuracy or applicability. People deciding
> 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, Second
> Author: The Complete Guide to SAS Indexes
> Sometimes the road less traveled is less traveled for a reason. - Jerry