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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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