topic How to create a SAS VA geo map time lapse in SAS Visual Analytics

How to create a SAS VA geo map time lapse

LukaszStasiak — Mon, 10 Jul 2017 09:59:49 GMT

Is there a way in SAS Visual Analytics in a Geo Map to not only show bibble as variety of width+color for my metrics, but also to create a timelapse of these?

For example I'm having parameter X as width and Y as color, now I want to select an hour of a selected day as the beggining of my filder/range and the end hour&day, so that in the given range of dates the bubbles will display different widths/colors as in a timelapse?

Re: How to create a SAS VA geo map time lapse

FalkoSchulz — Tue, 11 Jul 2017 00:22:37 GMT

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

Re: How to create a SAS VA geo map time lapse

LukaszStasiak — Tue, 11 Jul 2017 10:45:02 GMT

yeah I can see it now, unfortunately it's working only in Designer and not in Explorer mode, that's why I was confised 😉

What do I do, if my date&time field have duplicated values? when I'm putting the value in ANIMATION (Roles) the graph disappears and I see a warning "The data for this graps is not valid for animation. The data cannot contain any duplicated category and date combinations."

How do I solve it ?

Re: How to create a SAS VA geo map time lapse

Madelyn_SAS — Tue, 11 Jul 2017 13:36:10 GMT

Are you sure that you have duplicated values? I ask because this SAS note explains another reason why you would see that message. It appears if you exceed the cardinality limits for the geo map. You can filter to reduce the number of values.

http://support.sas.com/kb/60/337.html

Re: How to create a SAS VA geo map time lapse

LukaszStasiak — Tue, 11 Jul 2017 13:47:18 GMT

the article mentions 5000 rows limit, yet my variables which I'm tyring to use have respectively 1300 for datetime and 91 for dates. Neither works tho

Re: How to create a SAS VA geo map time lapse

FalkoSchulz — Wed, 12 Jul 2017 01:18:20 GMT

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