topic Canadian Cities geographic lookup table in SAS Visual Analytics

Canadian Cities geographic lookup table

don_data — Tue, 13 Mar 2018 21:02:45 GMT

Is there a lookup table for Canadian cities (eg: Vancouver, Calgary, Winnipeg) that is similar to the country lookup below:

http://support.sas.com/rnd/datavisualization/va63geo/subdivs.html

Thanks.

Re: Canadian Cities geographic lookup table

Sam_SAS — Wed, 14 Mar 2018 22:47:30 GMT

Hi Don,

We might add an easier way to map cities in the future, but currently you will need to add the city coordinates to your data set and then define a geography using custom coordinates.

If you have VA 8.2, or if you have a SAS/GRAPH license, then you can use the GEOCODE procedure to add the city coordinates to your data.

You can find documentation for GEOCODE here:

http://documentation.sas.com/?docsetId=grmapref&docsetTarget=p087i29802bnfgn1qn9isdqzde0h.htm&docsetVersion=9.4_01&locale=en

In particular, Example 5 should be helpful.

If you don't have access to GEOCODE, it is possible to add coordinates to your data in other ways but it is less convenient.

Let us know if this helps.

Sam

Re: Canadian Cities geographic lookup table

don_data — Wed, 21 Mar 2018 14:32:44 GMT

Thanks. Unfortunately, I do not have a SAS/GRAPH licence. Would you be able to provide me with the alternate method.

Thanks

Re: Canadian Cities geographic lookup table

Sam_SAS — Wed, 21 Mar 2018 14:51:54 GMT

Take a look at this thread:

https://communities.sas.com/t5/SAS-Visual-Analytics/Coordinates-for-Geo-Map/m-p/187450/highlight/true#M1335

There is a SAS macro script attached to the 11th post on that thread that uses Google APIs to geocode. The script itself is pretty arcane but some users on that thread apparently had success with it.

On the other hand, since you only need cities (as opposed to street addresses), you might want to search for a city coordinates table (for example, here https://www.maxmind.com/en/free-world-cities-database) and join these latitude and longitude variables into your data set.

Thanks,

Sam