Features: |
MAP= required argument referring to GfK map data DATA= argument referring to response data ID statement
|
Other features: |
System option FMTSEARCH= SQL procedure |
Data sets: | MAPSGFK.EUROPE (map data)
DEMOGRAPHICS (table of response data) |
Format: | ison2a |
Sample library member: | GMPGCHOR |
options fmtsearch=(sashelp.mapfmts);
proc sql; create table demographics(rename=(iso=oiso newiso=iso id=oldid newid=ID)) as select demo.*, put(demo.iso,z3.) as newiso format=$3., put(demo.iso,ison2a.) as newid from sashelp.demographics as demo ; alter table demographics modify ID char(15) label='Alpha2 Country Code'; quit;
goptions reset=all border;
title1 "Population in Europe"; footnote j=r "This map drawn with GfK map data";
proc gmap map=mapsgfk.europe(where=(id not in:('SJ' 'TR'))) data=demographics(where=(cont=93)) all; id id; choro pop / cdefault=yellow stat=first; run; quit;
proc sql; create table demographics(rename=(iso=oiso newiso=iso id=oldid newid=ID)) as select demo.*, put(demo.iso,z3.) as newiso format=$3., put(demo.iso,ison2a.) as newid from sashelp.demographics as demo ; alter table demographics modify ID char(15) label='Alpha2 Country Code'; quit;