BookmarkSubscribeRSS Feed
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.
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.

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:
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.
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.



Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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.

Get the $99 certification deal.jpg



Back in the Classroom!

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

View all other training opportunities.

Discussion stats
  • 3 replies
  • 3 in conversation