The Company has a footprint/presence mostly in the southern part of the United States. I have the brick and mortar locations at the street address, city, state and zip code level in a dataset. There are also some "outlier" locations in parts of the northern United States (I would like to have these separated from the rest of the footprint at the city location level) The Company has just implemented a new product/campaign and I have the customers utilizing that product at a city and state and zip code level (and if in the footprint by state and city). The product has associated with it a sports team logo that the customer can select. I would like to track/map the Company's footprint as the "backdrop" image with the customer location and team selection location overlaid. As it is a new product, the map detail could be based upon city but as the usage grows I think I would have to migrate to state information. Thus, I would need annotations for the number of brick and mortar locations for each state (or via a legend) and then a customer count for each state with a detail of team selection count. But, I am open to ideas and suggestions. So far, looking at the raw data, I have found it interesting that a customer in Louisiana would pick a team in Ohio for instance. The map might also indicate by team its fan/following by count or percent (or it may have to a secondary map visualization. My end goal is to show to marketing/management (if it exists) trends on customer purchase behavior and where there could be a justification for new targeting strategies at a location x outside of the Company footprint. I am a user of SAS Enterprise Guide but am not a "programmer/coder" but rather use query builder. I have scoured the SAS websites for examples and ideas but have found few that are able to generate a visual map when brought into the EG environment, let alone when I try to amend it with the Company's data. I am also at a loss as to how I "export" the resulting map with the annotation capabilities to a sharepoint site, website (intercompany google site for instance) etc. I have found several maps from the SAS sites that have "animation" capabilities as well - like the tornado activity over x period of years. Once I found that I thought it would be an idea to also create a multitude of similar maps over time to show management/marketing how the product purchases have increased (hopefully) and where that purchasing has occurred. Any assistance or answers would be greatly appreciated.
... View more