topic Re: SAS VA 8.3 can it plot data based on effectivity date (period)? in SAS Visual Analytics

SAS VA 8.3 can it plot data based on effectivity date (period)?

johnfrytz — Sun, 03 Oct 2021 21:58:36 GMT

Has anyone able to plot the data based on effectivity dates (period)?

Data sample:

Name Category Effective_from Effective_to

ID1 Group1 Jan 2021 Jun 2021

ID2 Group1 Jan 2021 May 2021

ID3 Group2 Jan 2021 Jul 2021

ID4 Group2 Jan 2021 Jun 2021

ID5 Group1 Jan 2021 Apr 2021

ID6 Group3 Jan 2021 Jun 2021

Can this be graphed in a line chart where all data will be counted each month and will no longer be counted once the effectivity period ends?

Thanks

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

ballardw — Mon, 04 Oct 2021 06:57:09 GMT

A "line chart" usually has some sort of numeric value involved. From context I would expect it to be other than the two date values you show.

I am afraid that without some "all data to be counted each month" we need to se some of that other data to have a chance.

It might mean that the example data you show is used to filter records from another data set with the values you expect to graph. If that is the case, the answer would be "very likely it can be plotted". Steps needed depend on data.

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

FredrikE — Mon, 04 Oct 2021 14:37:50 GMT

Hi!
I don't think it is possible without pre-arranging the data.
I usually join the interval-data with a calendar-dataset before loading it to VA, but the data grow very quick 🙂
//Fredrik

Re: SAS VA 8.3 can it plot data based on effectivity date (period)?

johnfrytz — Tue, 05 Oct 2021 01:33:04 GMT

I was trying to get away from having another set of data which either a monthly aggregate or transactional type (monthly as of status record).