topic Creating a dot map for 3 states in Graphics Programming

Creating a dot map for 3 states

einstein — Mon, 22 Jan 2018 21:56:57 GMT

I have the addresses (address line, city state, zip) for individuals in 3 states (DC,MD,VA) and trying to create a map that will show the 3 states together and plot each individual so that I can see where most of them are coming from.

Is there some code someone can share with me or point me to the right resources to do this?

Thanks!

Re: Creating a dot map for 3 states

againreddy — Thu, 25 Jan 2018 19:11:31 GMT

Please see the below

http://support.sas.com/resources/papers/proceedings16/10404-2016.pdf

Re: Creating a dot map for 3 states

PeterClemmensen — Sat, 27 Jan 2018 14:18:37 GMT

Post some sample data to get a code answer.

Also, see this

https://blogs.sas.com/content/graphicallyspeaking/2017/12/14/sgmap-now-in-base-sas/

Re: Creating a dot map for 3 states

GraphGuy — Mon, 29 Jan 2018 13:04:01 GMT

Here's one way to do it, using Proc Gmap and annotate ...

data my_data;
input statecode $ 1-2 value;
state=stfips(statecode);
datalines;
NC 491
SC 352
VA 108
;
run;

data my_map; set maps.us (where=(statecode in ('NC' 'SC' 'VA')));
run;

proc sql noprint;
create table anno_dots as
select unique my_data.*, uscenter.x, uscenter.y
from my_data left join maps.uscenter
on my_data.state=uscenter.state;
quit; run;

%let max_val=500; /* maximum size of data value to scale to */
%let max_area=40; /* size of the maximum dot you want in the map */
data anno_dots; set anno_dots;
length function $8 color $20;
xsys='2'; ysys='2'; hsys='3'; when='a';
function='pie'; rotate=360;
size=sqrt((value/&max_val)*&max_area/3.14);
color='dodgerblue'; style='psolid'; output;
color='gray33'; style='pempty'; output;
run;

pattern1 v=s color=grayf5;

proc gmap data=my_map map=my_map anno=anno_dots;
id statecode;
choro segment / levels=1 nolegend coutline=gray55;
run;