topic Re: Why the formating is not working for a spatial distribution map? in SAS Programming

Why the formating is not working for a spatial distribution map?

bd_user_10 — Thu, 15 Sep 2022 15:01:29 GMT

Hi Everyone,

I have been trying to create a spatial distribution map within 5 data ranges. Can someone please help me to detect why that's not working? The data ranges are given in the proc format section. Here are the codes:

goptions reset=all border;

title "County-level social capital levels, 2005";

proc gproject
data=maps.Counties
out=allcounties;
where state ne 2 and state ne 15 and state ne 72;
id state county;
run;

proc format ;
value sk_
1 = '-3.9094 - -1.0853'
2 = '-1.0852 - -0.5139'
3 = '-0.5138 - 0.0916'
4 = '0.0917 - 0.9486'
5 = '0.9487 - 14.2963'
;
run;

pattern1 v=s c=grayff;
pattern2 v=s c=grayaa;
pattern3 v=s c=graybb;
pattern4 v=s c=graycc;
pattern5 v=s c=graydd;

proc gmap
data=temp.social_capital_2005
map=allcounties all density=5;
id state county;
choro sk ;
format sk sk_.;
run;
quit;

I have also provided the data in the data section. Thanks in advance for your help.

The final output should be very similar to the 2005 sample in the link. https://aese.psu.edu/nercrd/community/social-capital-resources/us-maps-showing-county-social-capital-levels

Re: Why the formating is not working for a spatial distribution map?

ballardw — Thu, 15 Sep 2022 15:43:00 GMT

Your format for SK_ is incorrect. You attempt to use values of 1, 2, 3,4 and 5 for SK when the actual values are quite different.

Also, your indicated ranges overlap which is a no-no in general. Formats use value on the LEFT side of the = and display the value on the right side.

Try this format and see if things are better.

proc format ;
value sk_
 -3.9094 - -1.0852 = '-3.9094 - -1.0852'
 -1.0852< - -0.5138= '-1.0853 - -0.5138'
 -0.5138< - 0.0916 = '-0.5139 - 0.0916'
 0.0916< - 0.9486  = '0.0917 - 0.9486'
 0.9486< - high    = '0.9487 - 14.2963'
;
run;

the < in the ranges indicates an open interval, so does not overlap with the previous and provides rules for if there is an actual value of -1.08524.

@bd_user_10 wrote:

Hi Everyone,

I have been trying to create a spatial distribution map within 5 data ranges. Can someone please help me to detect why that's not working? The data ranges are given in the proc format section. Here are the codes:

goptions reset=all border;

title "County-level social capital levels, 2005";

proc gproject
data=maps.Counties
out=allcounties;
where state ne 2 and state ne 15 and state ne 72;
id state county;
run;

proc format ;
value sk_
1 = '-3.9094 - -1.0853'
2 = '-1.0852 - -0.5139'
3 = '-0.5138 - 0.0916'
4 = '0.0917 - 0.9486'
5 = '0.9487 - 14.2963'
;
run;

pattern1 v=s c=grayff;
pattern2 v=s c=grayaa;
pattern3 v=s c=graybb;
pattern4 v=s c=graycc;
pattern5 v=s c=graydd;

proc gmap
data=temp.social_capital_2005
map=allcounties all density=5;
id state county;
choro sk ;
format sk sk_.;
run;
quit;

I have also provided the data in the data section. Thanks in advance for your help.

The final output should be very similar to the 2005 sample in the link. https://aese.psu.edu/nercrd/community/social-capital-resources/us-maps-showing-county-social-capital-levels

Re: Why the formating is not working for a spatial distribution map?

bd_user_10 — Thu, 15 Sep 2022 16:59:44 GMT

Thanks that helped.
Need to add '/ discrete' after choro sk.