topic Re: Address list within a 5 miles radius of an address point in Graphics Programming

Address list within a 5 miles radius of an address point

MarcTC — Mon, 14 Feb 2011 22:01:27 GMT

I have street-level PROC GEOCODE installed. I want to know if it is possible to get a list of addresses within a 5 miles radius of an address point using SAS.

Re: Address list within a 5 miles radius of an address point

GraphGuy — Tue, 15 Feb 2011 00:04:43 GMT

First, you'll want to geocode all your addresses and get the lat/long for them.

Once you have the lat/long, there are several ways to determine which ones
are within a 5-mile radius of a given lat/long point.

You could calculate the distance from each point to the center using
the geodist() function, and then subset where that distance <= 5 miles.

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a003113162.htm

Another alternative - you could create a circular map area with a 5-mile radius,
and then use Proc GInside to determine which of the lat/long points are inside
that circle. Here is an example demonstrating that technique:

http://robslink.com/SAS/democd29/customer.htm
http://robslink.com/SAS/democd29/customer_info.htm

Re: Address list within a 5 miles radius of an address point

MarcTC — Tue, 15 Feb 2011 01:15:17 GMT

The project is sort of a marketing mailing campaign. We want to get the addresses of all the households within 5 miles radius of a store. I think USM, USP, USS datasets provided by street-level PROC GEOCODE should contains all addresses of the U.S. Just don't know how to get that needed information from them if it is possible.

Re: Address list within a 5 miles radius of an address point

EdO_sas — Tue, 15 Feb 2011 12:33:10 GMT

The USS PROC GEOCODE street lookup data set contains address ranges for each street. The left side of a street segment will have beginning and ending address values (for example, 1001-1099). However, the actual house numbers for individual structures along that street segment are not included. Those lookup data sets are generated from Census Bureau TIGER/Line files which include only street address ranges, not house numbers for individual structures.

Determining actual, deliverable addresses is provided by some of DataFlux's products. DataFlux is a SAS subsidiary, and info on their products should be available on the SAS site. Direct mailing campaigns, address cleaning and address verification are their specialties.