BookmarkSubscribeRSS Feed
MarcTC
Obsidian | Level 7
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.
3 REPLIES 3
GraphGuy
Meteorite | Level 14
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
MarcTC
Obsidian | Level 7
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.
EdO_sas
SAS Employee
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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon Kicks Off on June 11!

Watch the live Hackathon Kickoff to get all the essential information about the SAS Hackathon—including how to join, how to participate, and expert tips for success.

YouTube LinkedIn

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 7281 views
  • 0 likes
  • 3 in conversation