BookmarkSubscribeRSS Feed
ChrisH
Calcite | Level 5

Hi everyone,

 

I'm looking at the best way to perform address validation. Currently we have subscriptions with QAS and Google (this was down to COTS). We have an opportunity to reduce our subs down to just Google (again COTS dependency) however I'm strugging to find any information as to SAS integation with the Google Maps API.

 

Has anyone got any experience/advice in this area?

 

Thanks in advance.

 

Chris

4 REPLIES 4
Reeza
Super User

Where in the world are you? 

Have you looked at PROC GEOCODE at all? 

 

 

ChrisH
Calcite | Level 5

Thanks @Reeza.

 

I'm in the UK.

 

I'd seen PROC GEOCODE and basically had a muppet moment and not connected the dots. This may embarass me further but looking at the documentation it reads as if the geocoding information is shipped with SAS and therefore you don't need to punch out to a third party  - is that right?

 

Could life be getting simpler??? Smiley Happy

Darrell_sas
SAS Employee

Look at:  http://support.sas.com/rnd/papers/#2013

Then find the paper title:  PROC GEOCODE: Finding Locations Outside the U.S.

Under the title is a link to the paper and a link to the examples.

We do not have the street level geocoding in the UK.  We have Postal Code (ZIP Code) geocoding and world wide cities.

 

Unless you have a Google Map license, you should avoid using their free geocoder other than ON their maps.  You are not supposed to use it to store the data from their Geocoder.

That is why SAS doesn't have an integration with Google.

ChrisH
Calcite | Level 5

Thanks @Darrell_sas,

 

We have licences for both QAS and Google hence my intial thoughts.

 

It's a shame that it doesn't get down to street level as that would of been perfect however I guess we could look at the contruct of the address hand in hand with the post code validation. This would certainly remove additional coding to an api to call street level info.

 

Is there a pin in the roadmap to bring street level info in for the UK?

 

Thanks

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1063 views
  • 0 likes
  • 3 in conversation