topic Re: Adding longitude/latitude in sas tables? in New SAS User

Adding longitude/latitude in sas tables?

marleeakerson — Fri, 30 Aug 2019 15:41:34 GMT

Is it possible to add longitude and latitude to a sas table if we have the address and zipcode?

Trying to make a map in Tableau (which needs long and lat as opposed to just street address) but first I need to make the dataset in SAS.

Thank you!

Re: Adding longitude/latitude in sas tables?

ballardw — Fri, 30 Aug 2019 15:58:14 GMT

@marleeakerson wrote:

Is it possible to add longitude and latitude to a sas table if we have the address and zipcode?

Trying to make a map in Tableau (which needs long and lat as opposed to just street address) but first I need to make the dataset in SAS.

Thank you!

Search for GEOCODING

Possible but depending on your assets it may not be "easy".

SAS provides a Proc Geocode that is part of SAS/Graph. If you have access to this procedure there is an example in the documentation of street level geocoding of addresses using some SAS supplied TIGER street data. Caution: you may need to update that file from the SAS website as streets are constantly added and the version supplied with your SAS install may be out of date.

If you don't have SAS/Graph (or Proc Geocode and the associated SASHELP library data sets) you may have to decide how much $$$ is available for either adding licenses or other options.

How many addresses do you need to geocode? There may be some options for doing small numbers free using other tools.

Re: Adding longitude/latitude in sas tables?

Reeza — Fri, 30 Aug 2019 16:30:38 GMT

You need a license for SAS/GRAPH but yes it can.

You can check what you have licensed in SAS using:
proc setinit; run;
And what's installed on your system using:
proc product_status; run;
The output will be in the log.

Re: Adding longitude/latitude in sas tables?

marleeakerson — Fri, 30 Aug 2019 19:00:14 GMT

I have a license for SAS/GRAPH to use proc geocode. Do you have an example of code I could use a reference for turning street address into lat/long?

Re: Adding longitude/latitude in sas tables?

Reeza — Fri, 30 Aug 2019 19:07:07 GMT

This paper has a detailed overview

http://support.sas.com/resources/papers/proceedings10/332-2010.pdf

And the documentation has a fully worked example available here:

https://documentation.sas.com/?docsetId=grmapref&docsetVersion=9.4&docsetTarget=p1o71xg9evwp20n17x3n92qt1vgf.htm&locale=en

FYI I have found that you do need to do some cleaning and standardization of your data ahead of time to get really good results.

If you have access to SAS Data Quality Studio it does a decent job of cleaning up addresses and then geocoding them.