Fetch all addresses within a certain mile radius of an address

mraza12 — Tue, 23 Apr 2019 16:56:18 GMT

Hi,

I want to know if it's possible to find all addresses within a certain mile radius of an address (For instance, 123 Random St, City, 12345).

I just want to find any address that falls within a certain mile radius of an address. I do not have any list of addresses that I want to get a match on (and that's not what I'm looking for).

Also, if there is a list of all US address stored in a SAS library. Maybe I could use that to match it against my address. I am not certain if there is one.

Thanks for the help!

Re: Fetch all addresses within a certain mile radius of an address

ChrisNZ — Fri, 26 Apr 2019 02:30:33 GMT

You can get US addresses here.

http://support.sas.com/rnd/datavisualization/mapsonline/html/geocode.html

As for the join based on distance, you can use function GEODIST.

Be aware that if you have many addresses to match, it can get very slow very quickly unless you are clever and optimise the join.

topic Re: Fetch all addresses within a certain mile radius of an address in SAS Programming

Fetch all addresses within a certain mile radius of an address

Re: Fetch all addresses within a certain mile radius of an address