Data visualization with SAS programming

PROC GMAP MIDPOINTS option

Reply
Super Contributor
Posts: 543

PROC GMAP MIDPOINTS option

Hi,

I am creating several US maps, and the response variable is continuous. I do this for a series of years.

I noticed that for different data, I need to use different MIDPOINTS options to make the categories correctly on the map.

Sometimes I need to use

MIDPOINTS = OLD RANGE

and sometimes

MIDPOINTS = 0 3 8 ...(or an exact set of values)

Could anyone explain the difference.

(I have read about MIDPOINTS, and all I found was that

Specifying MIDPOINTS=OLD generates default midpoints using the Nelder algorithm (Applied Statistics 25:94-7, 1976).  (SAS/GRAPH(R) 9.2: Reference, Second Edition)

Maybe someone can explain this a bit?

Thank you.

Anca.

SAS Employee
Posts: 967

Re: PROC GMAP MIDPOINTS option

Do you want the legends of all the maps to be the same, so you can compare them?

If I don't need the legends to be the same, and I basically want to "auto-scale" the legend, I just use levels=5

Super Contributor
Posts: 543

Re: PROC GMAP MIDPOINTS option

Yes, the legends should be the same.

SAS Employee
Posts: 967

Re: PROC GMAP MIDPOINTS option

If you want the legend ranges to be guaranteed to be the same in all the maps, you won't be able to just use the midpoints= option. Instead you'll need to manually determine which range each data point falls in (using a data step and 'if/else' statements), and put each into a 'bucket', and then use the midpoints= option to specify the buckets (to make sure they all show up in each map, regardless of whether there are any obsns in that bucket in that particular data). And you can use a user-defined-format to make the buckets print showing the legend ranges.

Here are some code snippets that might help get you started ...

proc format;
value buckfmt
1 = '1-7'
2 = '8-15'
3 = '16+'
;
run;

data my_data; set my_data;
format bucket buckfmt.;

if cases<=7 then bucket=1;
else if cases<=15 then bucket=2;
else if cases>=16 then bucket=3;

run;

proc gmap data=my_data map=maps.us all;

id statecode;

choro bucket / discrete midpoints=1 2 3;

run;

Super Contributor
Posts: 543

Re: PROC GMAP MIDPOINTS option

Thank you, Robert.

I guess my question was more geared towards understanding why when I defined specific values for the midpoints, the buckets seem to be ever so slightly off, but it gets fixed by MIDPOINTS = OLD RANGE option. And for other data it works like a charm (the midpoints = specific values).

Anca.

SAS Employee
Posts: 967

Re: PROC GMAP MIDPOINTS option

Unless you're dealing with discrete values (and using the discrete option), I think the midpoints= option is going to provide varying ranges in your legend (depending on what data you're plotting). I never truse the midpoints= option to choose my legend ranges.

Respected Advisor
Posts: 3,775

Re: PROC GMAP MIDPOINTS option

RobertAllison@SAS wrote:

Instead you'll need to manually determine which range each data point falls

I have found the XML routine CALL GSCALE useful for data-driven uniform axis calculations.

Ask a Question
Discussion stats
  • 6 replies
  • 849 views
  • 6 likes
  • 3 in conversation