Fetch all addresses within a certain mile radius of an address

[mraza12]

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!

[ChrisNZ]

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.