Usage Note 45532: Lookup data for city geocoding with PROC GEOCODE
Starting with the second maintenance release of SAS® 9.3 (TS1M2), the default lookup data set for U.S. CITY geocoding is MAPSGFK.USCITY_ALL.
Prior to SAS 9.3 (TS1M2), Sashelp.Zipcode is the default lookup data set that the GEOCODE procedure uses to perform city geocoding. The Sashelp.Zipcode data set contains one city per ZIP code in the City variable. The City variable contains the city in which the U.S. Post Office is located.
However, multiple cities can be associated with the same ZIP code. In these circumstances, the Alias_City variable in the Sashelp.Zipcode data set contains a list of those cities.
Before performing city geocoding, you should modify the Sashelp.Zipcode data set using the code on the Full Code tab to add the Alias_City values to the City variable. You can then specify the new Zipcode data set in the LOOKUP= option in PROC GEOCODE.
Operating System and Release Information
| SAS System | SAS/GRAPH | z/OS | 9.2 TS1M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | |
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | |
| Microsoft® Windows® for x64 | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |
| Microsoft Windows XP Professional | 9.2 TS1M0 | |
| Windows Vista | 9.2 TS1M0 | |
| Windows Vista for x64 | 9.2 TS1M0 | |
| 64-bit Enabled AIX | 9.2 TS1M0 | |
| 64-bit Enabled HP-UX | 9.2 TS1M0 | |
| 64-bit Enabled Solaris | 9.2 TS1M0 | |
| HP-UX IPF | 9.2 TS1M0 | |
| Linux | 9.2 TS1M0 | |
| Linux for x64 | 9.2 TS1M0 | |
| OpenVMS on HP Integrity | 9.2 TS1M0 | |
| Solaris for x64 | 9.2 TS1M0 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Before performing city geocoding, you should modify the Sashelp.Zipcode data set using the code below to add the Alias_City values to the City variable. You can then specify the new Zipcode data set in the LOOKUP= option in PROC GEOCODE.
data zipcode;
set sashelp.zipcode;
output;
if alias_city ne '' then do;
number=countw(alias_city,'||');
do i=1 to number;
city=scan(alias_city,i,'||');
output;
end;
end;
run;
The default lookup data set used by the GEOCODE procedure to perform city geocoding is Sashelp.Zipcode.
| Date Modified: | 2012-02-03 15:51:22 |
| Date Created: | 2012-01-30 13:01:34 |