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: | GMPGROSU |
options fmtsearch=(sashelp.mapfmts);
proc sql; create table demographics(drop=iso id rename=(oiso=iso isoalpha2=id)) as select demo.*, names.id, names.isoalpha2, put(names.iso,z3.) as oiso format=$3. from sashelp.demographics as demo join newnames as names on names.id=demo.id ; quit;
goptions reset=all border;
title1 "Population in Europe (2005)"; footnote1 j=r "This map drawn with GfK map data";
proc gmap map=mapsgfk.europe data=demographics; id id; surface pop / stat=mean constant=4 nlines=100 rotate=40 tilt=60; run; quit;
proc sql; create table demographics(drop=iso id rename=(oiso=iso isoalpha2=id)) as select demo.*, names.id, names.isoalpha2, put(names.iso,z3.) as oiso format=$3. from sashelp.demographics as demo join newnames as names on names.id=demo.id ; quit;