Data visualization with SAS programming

Address list within a 5 miles radius of an address point

Reply
Frequent Contributor
Posts: 77

Address list within a 5 miles radius of an address point

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.
SAS Employee
Posts: 967

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

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
Frequent Contributor
Posts: 77

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

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.
SAS Employee
Posts: 23

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

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.
Ask a Question
Discussion stats
  • 3 replies
  • 1883 views
  • 0 likes
  • 3 in conversation