MAPIMPORT Procedure

Example 5: Including Selected Variables from the DBF Shapefile

In the following example, the STATES.DBF file contains the identification information (field-identifier names and values) applied to the U.S. states polygon map. Only the STATE_FIPS (the state FIPS codes), STATE_NAME (the state names), and STATE_ABBR (the two letter state abbreviations) variables are included in the traditional map data set, MYDATA. STATE_FIPS is renamed FIPS, STATE_NAME is renamed STATE, and STATE_ABBR is renamed ABBREV in the MYDATA map data set.
PROC MAPIMPORT OUT=mydata DATAFILE="C:\states.dbf";
     SELECT STATE_FIPS STATE_NAME STATE_ABBR;
     RENAME STATE_FIPS=FIPS STATE_NAME=STATE STATE_ABBR=ABBREV;
run;