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

[johnfrytz]

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

[ballardw]

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.

[johnfrytz]

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).

[FredrikE]

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