Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

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.
 
Note for z/OS sites:  You should move the zipcode.cpt file 
to z/OS in binary mode, to a file with DCB characteristics of 
RECFM=FB, LRECL=80, BLKSIZE=8000. 

Operating System and Release Information