Date: Sat, 21 May 2011 16:08:55 +0000
Reply-To: Michael Raithel <michaelraithel@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Michael Raithel <michaelraithel@WESTAT.COM>
Subject: Re: Slightly OT, But Still SAS Related
Content-Type: text/plain; charset="us-ascii"
Jack posted the following:
> "Correlates" is the right word, because ZIP codes are not guaranteed to
> cover only a single city, county or state. But they almost always
> match at the state level, and the usual method of choosing the entity
> with the largest population works for the other geographic levels.
> The sashelp.zipcodes data set has already been mentioned, a version
> current through April 2011 is available at
> >. Some older ZIP+4 data can be found at
> I wonder if the new geocoding feature in SAS/Graph 9.2 is being used
Jack, thanks for this and thanks also to Michelle, Joe W., and Nat for providing additional insights!
I took the initiative and downloaded the file, above, though I believe our clever SAS techie staff does this every... (um quarter?)... time the new one is released. I CIMPORTED the data sets in the transport file, selected out the Massachusetts observations (703), then did a PROC SORT with a NODUPKEY BY STATE COUNTYNM. I was pleased to see that there were no dropped observations, so in this particular file zip codes did not overlap Massachusetts counties. Consequently, I dumped the file of Massachusetts obs into an Excel spreadsheet and passed it on to the project staff.
Thought the list would like to hear a happy ending for once, as not enough help-ees write back to let us know how their particular story ended.
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"
Author: Tuning SAS Applications in the MVS Environment
Author: Tuning SAS Applications in the OS/390 and z/OS Environments, Second Edition
Author: The Complete Guide to SAS Indexes
Everything zen, everything zen; I don't think so... - Everything Zen by Bush