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

Product Family	Product	System	SAS Release
			Reported	Fixed*
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.

Type:	Usage Note
Priority:

Date Modified:	2012-02-03 15:51:22
Date Created:	2012-01-30 13:01:34