Features: |
MAP= required argumentreferring to GfK map data DATA= argument referring to response data FORMAT statement ID statement AREA statement option MIDPOINTS=
|
Other features: |
System option FMTSEARCH= SQL procedure FORMAT procedure LEGEND statement |
Data sets: | MAPSGFK.ASIA (map data)
DEMOGRAPHICS (table of response data) |
Format: | ison2a |
Sample library member: | GMPGFRMT |
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;
proc format; value popfmt low-1000000="0-1" 1000001-10000000="1-10" 10000001-100000000="10-100" 100000001-500000000="100-500" 500000001-high="over 500"; run;
proc format; value $ regionfmt "SEAR" = "South-East Asia" "EUR" = "Europe" "EMR" = "Eastern Mediterranean" "WPR" = "Western Pacific"; run;
title1 "Population Data for Asia (2005)"; footnote j=r "This map drawn with GfK map data";
legend1 label=("Population (Millions)");
proc gmap data=demographics(where=(cont=95)) map=mapsgfk.asia all; format pop popfmt.; format region $regionfmt.; id id; area region / midpoints="SEAR" "EUR" "EMR" "WPR"; block pop / legend=legend1 relzero levels=all; 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;
proc format; value popfmt low-1000000="0-1" 1000001-10000000="1-10" 10000001-100000000="10-100" 100000001-500000000="100-500" 500000001-high="over 500"; run;
proc format; value $ regionfmt "SEAR" = "South-East Asia" "EUR" = "Europe" "EMR" = "Eastern Mediterranean" "WPR" = "Western Pacific"; run;