Usage Note 19861: How to replace the SASHELP.ZIPCODE data set
The ZIPCITY function uses the SASHELP.ZIPCODE data set to return a city
name and the two-character postal code that corresponds to a ZIP code.
Since ZIP codes can change frequently, the ZIPCODE data set needs to be
updated as well. Updated versions of the ZIPCODE data set are available
in the Maps Online facility:
http://support.sas.com/rnd/datavisualization/mapsonline/html/misc.html
You can download the CPORT file corresponding to the version of the
ZIPCODE data set that you want. Once you have that file, you will need
to do the following to replace the existing SASHELP.ZIPCODE data set:
1. Use the CIMPORT procedure to import the file into a SAS data library.
For example:
proc cimport file='zipcode.cpt' lib=sashelp;
run;
2. Use the DATASETS procedure to delete the existing ZIPCODE data set
from the SASHELP library and rename the new ZIPCODE data set and
index from the unique name representing the version of the ZIP code
file to be ZIPCODE. For example:
proc datasets lib=sashelp;
delete zipcode;
run;
change zipcode_unique=zipcode;
run;
quit;
Note the you must have write access to the SASHELP library in order to
place the data set in the library.
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/GRAPH | Microsoft Windows NT Workstation | 8.2 TS2M0 | |
| Microsoft Windows XP Professional | 8.2 TS2M0 | |
| Microsoft Windows 95/98 | 8.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 8.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 8.2 TS2M0 | |
| Windows Millennium Edition (Me) | 8.2 TS2M0 | |
| Microsoft Windows 2000 Professional | 8.2 TS2M0 | |
| Microsoft Windows 2000 Server | 8.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 8.2 TS2M0 | |
| Microsoft Windows 2000 Advanced Server | 8.2 TS2M0 | |
| Microsoft Windows 2000 Datacenter Server | 8.2 TS2M0 | |
| OpenVMS VAX | 8.2 TS2M0 | |
| IRIX | 8.2 TS2M0 | |
| Solaris | 8.2 TS2M0 | |
| 64-bit Enabled Solaris | 8.2 TS2M0 | |
| OS/2 | 8.2 TS2M0 | |
| Linux | 8.2 TS2M0 | |
| z/OS | 8.2 TS2M0 | |
| ABI+ for Intel Architecture | 8.2 TS2M0 | |
| CMS | 8.2 TS2M0 | |
| HP-UX | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | |
| OpenVMS Alpha | 8.2 TS2M0 | |
| 64-bit Enabled AIX | 8.2 TS2M0 | |
| Tru64 UNIX | 8.2 TS2M0 | |
| AIX | 8.2 TS2M0 | |
*
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.
| Type: | Usage Note |
| Priority: | |
| Topic: | Query and Reporting ==> Creating Reports ==> Graphical ==> Graph Types ==> Maps
|
| Date Modified: | 2007-03-27 16:50:34 |
| Date Created: | 2007-03-27 16:50:34 |