Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Geo bubble map not displaying # geography items because matching latitude and longitude not found.

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 135
Accepted Solution

Geo bubble map not displaying # geography items because matching latitude and longitude not found.

Hello all,

I have my bubble map working now thanks SAS Tech-Support. New question, it seems I might have either bad data or a new zip codes that are not yet mapped to a geography latitude and longitude. Can anyone tell me where/how to test these two ideas and fix my missing three items warning? When I searched on Google.com for SAS and this (subject) no hits, and when I search the Community I also do not get a hit.  TIA. 
PS would love to know a table I might select the zips that are mapped in SAS VA so I can do a difference query, or just have SAS VA display them in some sub filter list etc. -KJ


Accepted Solutions
Solution
‎06-29-2018 10:29 AM
SAS Super FREQ
Posts: 586

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to FalkoSchulz

Would this sample help you find the non-matching ZIP codes?

 

http://support.sas.com/kb/50/776.html

 

View solution in original post


All Replies
Frequent Contributor
Posts: 135

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to kjohnsonm
PS if it matters I am on SAS VA 7.3.
SAS Super FREQ
Posts: 106

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to kjohnsonm

There are two ways to geo map your data. You either add related latitude/longitude columns to your data source and create a custom geographical item or you select one of the provided lookup options. The doc http://support.sas.com/documentation/cdl/en/vaug/68648/HTML/default/viewer.htm#p1ql9ufve83ojen1qoqux... explains how to create such items. VA also ships with a set of geographical lookup values including countries, states, zip codes, etc. - expected values are listed is here http://support.sas.com/rnd/datavisualization/vageo/71/VA71LookupValues.html . If your data comes in the right format you can choose the related option when creating the geographical item and any overlay (e.g. bubble or coordinates) should render as expected. 

 

If this doesn't help - maybe you can share a snapshot of your data or add some more details.

 

Hope this helps. Regards, Falko

Frequent Contributor
Posts: 135

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

[ Edited ]
Posted in reply to FalkoSchulz

If I was not clear, I can map just fine with my data for 5 million obs, I have exactly 3 zips or 3 obs (I am not sure which) that do not map.  I think they are either bad data or a new zip(s), and I wanted to know how to find them via a query, or just display the non-map-able zip numbers in a separate tab or etc. in SAS VA.  Please see bottom right side of this attached map. I do not want to manually manage 5Mill obs for zip to lat/log. Thanks for your response. If I am misunderstanding your attempt to help I am sorry but think you are trying to help me make data map-able in the first place. I already have a "generally" clean zip (5 digits only) in other words not zip+4 column. I am trying to find the obs that is causing this warning in the [bottom] right of my example.

SAS Super FREQ
Posts: 106

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to kjohnsonm

I see. Are you able to generate the map using Visual Analytics Explorer? I believe the explorer interface will show more details in the bottom right corner along with values which couldn't be mapped. Maybe this helps to find the items in question. 

 

Also, can you quickly describe how you defined your geo item? Did you use the existing US Zip Code option or did you create a custom geo item using related latitude/longitude? Using the US Zip code option is based on the table SASHELP.ZIPCODE and you may be able to use a SQL join to find non-matching items.

 

Let us know how you go. Hope this helps.

 

Thanks, Falko

Solution
‎06-29-2018 10:29 AM
SAS Super FREQ
Posts: 586

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to FalkoSchulz

Would this sample help you find the non-matching ZIP codes?

 

http://support.sas.com/kb/50/776.html

 

Frequent Contributor
Posts: 135

Re: Geo bubble map not displaying # geography items because matching latitude and longitude not foun

Posted in reply to Madelyn_SAS
Madelyn, Happy read this information and annoyed that my search did not pop this as the number one hit to the exact error message found in SAS VA. Thank you very much. -KJ
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 162 views
  • 1 like
  • 3 in conversation