topic VA 7.3 Geography and Latitude and Longitude in SAS Visual Analytics

VA 7.3 Geography and Latitude and Longitude

mhamlett — Thu, 26 May 2016 19:13:38 GMT

i use VA 7.3

i can use maps with 2 letter state code States.

2 questions

1)how do i setup for a drill down to city level?

2) my data source has latitude and longitude values which i use in other mapping applications. when i go to custom geography. i get a screen that shows possible fields for lat/long. when i click the drop down for the latitude field, a list of fields is shown but my latitude field is not in the dropdown. the longitude is in the drop down.

any ideas why?

thanks

Re: VA 7.3 Geography and Latitude and Longitude

ballardw — Thu, 26 May 2016 19:19:15 GMT

My first guess would be that your latitude is not numeric, possibly due to the presence of one or more of degree and/or second symbols, :, or N/S.

Re: VA 7.3 Geography and Latitude and Longitude

mhamlett — Thu, 26 May 2016 19:26:49 GMT

figured out the city. i have to use zip code.

apparently city not allowed.

Re: VA 7.3 Geography and Latitude and Longitude

ballardw — Thu, 26 May 2016 19:28:51 GMT

Since many cities have multiple Zip codes you might want to consider consolidation to a main one if your desire is a report based on City.