Starting with the second
maintenance release of SAS 9.3, the default lookup data set for world
CITY geocoding is MAPSGFK.WORLD_CITIES. This data set contains more
than 200,000 cities worldwide. The data set is licensed by SAS from
GfK GeoMarketing GmBH, who is the single source of this data and all
of its updates. The data set is covered by the GfK GeoMarketing copyright,
is provided with
SAS/GRAPH in the MAPSGFK library, and is updated
for each SAS release.
You can download updates
of the MAPSGFK.WORLD_CITIES data set from the SAS Maps Online Web
site. An unabridged data set named MAPSGFK.WORLD_CITIES_ALL, with
more than one million observations, is also available for downloading.
The unabridged data set is updated annually.
For more information,
see SAS Maps Online Web Site.
You can specify that
non-geocoding variables from the lookup data set be added to the output
data set by using the ATTRIBUTEVAR= option in the PROC GEOCODE statement.
The default lookup data
set MAPSGFK.WORLD_CITIES and the unabridged data set MAPSGFK.WORLD_CITIES_ALL
both contain the following variables:
Projected longitude
using the experimental Miller II projection method.
Projected latitude
using the experimental Miller II projection method.
Normalized state or
province name for geocoding.
Note: Values are uppercased and
stripped of all spaces and characters that are not alphabetic or
numeric.
Normalized CITY name
for geocoding.
Note: Values are uppercased and
stripped of all spaces and characters that are not alphabetic or
numeric.
Numeric number for
continent.
POP categories for
cities where applicable.
Grouping of CtType
high to low.
Unprojected degrees
longitude.
Unprojected degrees
latitude.
ISO Alpha2-code for
country.
ISO Alpha3-code for
country.
ID from MAP data set.
Note: The map data set specified
in the
SAS/GRAPH GMAP procedure
IDNAME from MAP data
set.
Note: The map data set specified
in the
SAS/GRAPH GMAP procedure
ID1NAME from MAP data
set