gmap partial maps of canada and usa

capam — Fri, 15 Dec 2017 13:42:59 GMT

I wrote the following gmap input data and got an error for the canada part.

/* Combine the map data set with the annotate data set. */
data all;
	/* Subset out the states that you do not want. */
	/* The FIPS code of 2 is Alaska, 15 is Hawaii, */

	/* and 72-Puerto Rico. California-6 Florida-12 
	Oregon-41 Nevada-32 Arizona-4*/
	set maps.states(where=(state not in(2 4 6 12 15 32 41 72))) 
		maps.canada(where=(province not in(10:13 60 61))) anno;
		*anno;

	*maps.canada4 anno;
	*maps.canada4(where=(province not in(10:13 60 61))) anno;
run;

The error message is:

93 data all;
94 /* Subset out the states that you do not want. */
95 /* The FIPS code of 2 is Alaska, 15 is Hawaii, */
96
97 /* and 72-Puerto Rico. California-6 Florida-12
98 Oregon-41 Nevada-32 Arizona-4*/
99 set maps.states(where=(state not in(2 4 6 12 15 32 41 72)))
100 maps.canada(where=(province not in(10:13 60 61))) anno;
ERROR: WHERE clause operator requires compatible variables.

I would appreciate help in correcting this error.

Thanks.

Re: gmap partial maps of canada and usa

ballardw — Fri, 15 Dec 2017 23:22:28 GMT

In my Maps.canada dataset Province is character. You would have to use

maps.canada(where=(province not in('10' '11' '12' '13' '60' '61')

the value list '10':'13' does not work with character values because '101' would be "between" '10' and '13'. And because there are so many possible issues with inclusion for character SAS has just skipped that coding issue and doesn't allow it.

The error message

ERROR: WHERE clause operator requires compatible variables

means that you are comparing a text variable to numeric somewhere.

topic gmap partial maps of canada and usa in SAS Visual Analytics

gmap partial maps of canada and usa

Re: gmap partial maps of canada and usa