Features: |
MAP= required argument referring to GfK map data DATA= argument referring to response data ID statement FORMAT statement
|
Other features: |
System option FMTSEARCH= SQL procedure |
Data sets: | MAPSGFK.AFRICA (map data)
DEMOGRAPHICS (table of response data) |
Format: | ison2a |
Sample library member: | GMPGMDPT |
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 "Adult Literacy Rate"; footnote1 j=r "This map drawn with GfK map data";
proc gmap data=demographics(where=(cont=94)) map=mapsgfk.africa(where=(lake=0)) density=low all; id id; format adultliteracypct percentn7.2; prism adultliteracypct / midpoints=.10 to .90 by .20 cdefault=yellow; 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;