How I can calculate the distance between two addresses?

[Agha]

I should calculate the distance between home addresses and closest eye clinic. The addresses are saved in excel. Street, city and state have separate columns. I know I should add double quotation to each part of  the addresses and then find the distance. Can you please share the codes with me. I can not share the addresses with you but they are similar the list below. Thanks.

Street                       state           City

aaa bbb ccc             DD             mnv

aa dddd eee            DD              dvu

ffff oo nnm              DD             lmn

[Reeza]

You need an api to get driving distances. If you can use flying distances (straight line distance) then you can use proc geodist and geocode function.

Use PROC geocode to convert addresses to latitude and longitude and then the geodist() function to calculate the flying distance. 

https://support.sas.com/en/knowledge-base/maps-geocoding/geocodes.html#:~:text=Use%20the%20PROC%20GE....

Paper on the topic

https://support.sas.com/resources/papers/proceedings17/0155-2017.pdf

Or try this method - note you need the latitude/longitude for this one or need to modify the URL portion.

https://communities.sas.com/t5/SAS-Programming/Find-driving-distance-google-maps-usinga-list-of-10-h...

[sbxkoenk]

By the way,
You can also do reverse geocoding in SAS.

Home > SAS Communities Library > Reverse Geocoding Using PROC GINSIDE
Reverse Geocoding Using PROC GINSIDE
Started 4 weeks ago | Modified 4 weeks ago
https://communities.sas.com/t5/SAS-Communities-Library/Reverse-Geocoding-Using-PROC-GINSIDE/ta-p/895...

BR,
Koen

[sbxkoenk]

See here :

• Driving Distances and Drive Times using SAS and Google Maps
  Started ‎07-05-2018 | Modified ‎07-05-2018
  https://communities.sas.com/t5/SAS-Communities-Library/Driving-Distances-and-Drive-Times-using-SAS-a...
• Driving Distances and Times Using SAS® and Google Maps
  Mike Zdeb
  University at Albany -- School of Public Health
  https://www.sas.com/content/dam/SAS/en_ca/User%20Group%20Presentations/TASS/Zdeb-DrivingDistances.pd...
• Paper BI02-2016
  Macro method to use Google Maps™ and SAS® to find the shortest driving and straight line distances between 2 addresses in the United States
  Laurie Bishop, Cincinnati Children’s Hospital Medical Center, Cincinnati, Ohio
  https://www.mwsug.org/proceedings/2016/BI/MWSUG-2016-BI02.pdf

BR,
Koen

[sbxkoenk]

Home > Programming > Programming >
Re: Find driving distance (google maps) using a list of 10 hospital addresses and individual zipcode
SOLVED topic
https://communities.sas.com/t5/SAS-Programming/Find-driving-distance-google-maps-usinga-list-of-10-h...

Koen