Can you share a few more information how you are loading the data into memory? What version of VA are you using? It seems odd that some columns (e.g. "X") get loaded as category but others (e.g. "Y") recognized correctly as measure. Does the VA Administrator show the same classification? Unless you are using a CSV file - typically column metadata are retrieved from the source SAS data set.   Can I assume you are using the latest version of the world cities data set as per download option here: https://support.sas.com/downloads/download.htm?did=105415 ?   Cheers, Falko ... View more

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=n1korpfg2e18lon1nwpow9qijdxe.htm&locale=en ) 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-SAS-Visual/ta-p/233181 ). 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 ... View more

Hi,    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.    Drive-distance analysis with SAS Visual Analytics   This may not exactly be what you are after but maybe gives you a few ideas to get started.   Hope this helps. Falko ... View more

While we don't support heat map / density plots just yet (planned for future releases) - I found it best to use the geo coordinates plot for high cardinilaty maps. So things like US zip codes with over 40k values typically render better with smaller data points. The following screenshot shows an example for US with 80% transparency:     Zooming into the east coast reveals more details:     As Sam mentioned - you may also consider using regional overlay if you have access to the boundary data. Given the number of zip codes however you may not be able to render all data points for performance reasons. The following examples shows Florida:     Hope this helps. Regards, Falko ... View more

Yes, this should work. Just make sure to configure ADDRESS as custom geographical item (so specify the LAT,LNG columns as coordinates) and use the DATE as animation role on the geo map. The VALUE column can be either the size or color of the bubble.   Hope this helps. Cheers, Falko ... View more

We also have a basic example of the expected data set structure in the user guide: https://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#p06eosr7smtwskn1qphlego3bso8.htm . The example uses a manager-employee relationship but is very similar to what you are trying to achieve. Make sure to include leaf-nodes at least once in the source column as per documentation - otherwise these aren't rendered due to missing node attributes.   Let us know how you go! Cheers, Falko ... View more

I believe this message is shown if you have more than one date for one ore more geo categories. Are you able to either aggregate (change the format on the date field) or filter out the relevant entries? Maybe you can use a crosstab using both the date and geo category and check for entries with frequency > 1. Hope this helps. Falko ... View more

One of the supported roles is 'animation'. When a date field is assigned to this role - the geo map will animate data over time and as such show the data as timelapse. More information about supported roles is in the VA user guide: https://support.sas.com/documentation/cdl/en/vaug/69957/HTML/default/viewer.htm#n1xeoy8ws5rm3rn1pi4y1ky0ngs6.htm   Hope this helps.   Cheers, Falko ... View more

Thanks Luciano for taking the time to update this discussion with your solution. I'm sure others will benefit from any information and details we provide. Thanks again and glad you got it working. Regards, Falko ... View more

Can you confirm that the library which holds your custom boundary data is pre-assigned? Have you made necessary changes in the user autoexec file as per instructions? Also, make sure your boundary data file ends with the suffix "1" and is properly registered in the mapfile-column in centrlookup.   fyi - a similar discussion and related resolution is in thread https://communities.sas.com/t5/SAS-Visual-Analytics/GeoMapping-with-SAS-VA/m-p/368549 - maybe some of the ideas apply to your environment as well.   Hope this helps. Cheers, Falko ... View more

Note, that custom polygons are now officially supported in VA 7.4 and covered in the adminstration document at https://support.sas.com/documentation/cdl/en/vaag/69958/HTML/default/viewer.htm#n0g5kjtnbvsrwbn1lxl2wahyc5du.htm. It also comes with an example for US Counties. Cheers, Falko ... View more