I am looking for a way if it is possible using SAS Visual Analytics GeoMap to list a bunch of customers using their zip codes. Then place a non-related zip code on the map and get the distances between the customers and the non-related zip code.
I'm not sure what version of SAS Visual Analytics you are using - but with release 8.1 or later you have access to things like location search, radius as well as drive-distance/drive-time (requires an Esri ArcGIS online account) selections.
The below example screen, shows known ZIP codes around L.A. county and a drive-distance analysis has been run - showing the customers within the 5, 10 and 15 miles radius (the gray shaded polygons). The point of measurement is the L.A. Int'l Airport (marker #9). You can perform address searches (e.g. for a specific customer) by using the top left search field. I just searched for 'Airport' to make this example. Typically you would have other visualizations which show details about the customers (e.g. a table with address or sales figures) linked to this geo map.
This may not exactly be what you are after but maybe gives you a few ideas to get started.
Hope this helps. Falko
The enhanced location analytic options were introduced in version 8.x. Unfortunately I'm not aware of a similar capability in version 7.x or earlier.
If you have the coordinates for both the customers and zip codes - you could try using functions such as PROC GEODIST (doc is here: http://go.documentation.sas.com/?cdcId=pgmmvacdc&cdcVersion=9.4&docsetId=lefunctionsref&docsetTarget... ) which can calculate the distance between two geographical points. Dependent on your data structure you may be able to calculate distances between customers and related ZIP codes. This could be packaged as a SAS Stored Process for example showing the closest customers given a passed in ZIP code (A quick guide to get started is here: https://communities.sas.com/t5/SAS-Communities-Library/Quick-Guide-to-Using-SAS-Stored-Processes-in-... ). Alternatively - if you do an Internet search for a formula to calculate distances between two latitude/longitude points - you may also find more generic versions (some are more complicated than others) which you can use directly in VA as calculated data item.
Hope this helps. Cheers, Falko
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.