I am trying to create a Geo Bubble map in SAS VA to map total shipments to locations and animate it over time. The animation aspect is supposed to show how shipments have grown over time so the bubbles would constantly be on the map and will grow each time there is another shipment to that location. I was able to get all of the data loaded in and animate it over time; however, the bubbles would pop up quickly on the day of the shipment then disappear after the date had passed. In the attached file, this data is found in the "DOE Shipment" tab. In an attempt to fix this issue, I reorganized the data so that there was a running total of the volumes shipped to each destination. That is to say, there is an observation for each day and each location that says how much volume has been shipped to that location from 1/1/17 up until that day. In the attached file, this data is found the the "Clean Data" tab. I was hoping this would make the bubbles stay on the screen as time passed but instead received an error message. The error says "The data for this graph is not valid for animation. The data cannot contain any duplicated category and date combinations." I assume this is because there are multiple observations with the same date, just for different locations. In SAS VA, I assigned "Country of Destination" as the "Geography" role, using the lat and long variables. I used "Total Volume" for the "Size role" and "Date" for "Animation." Any help someone might have would be greatly appreciated.
... View more