The direction of change over time

PatrykSAS — Tue, 24 Nov 2020 13:49:46 GMT

Hello. I have a problem with showing the information that the report should contain. I want to show how many ID has changed its indicator value to another specific indicator in a certain time period. The table is similar to the one below.

ID	DATE	INDICATOR (X,Y,Z)
1	2020-09	0
1	2020-10	1
1	2020-11	1
2	2020-09	0
2	2020-10	1
3	2020-10	3
3	2020-11	1

So example, report user wants to check how many IDs has changed their indicator from 0 to 1 between 2020-09:2020-10. The answer is 2 (ID 1 and 2). However, if he wanted to change the time range to 2020:09-2020-11 then the answer is 1 (ID 2 didn't appear in 2020-11 date so we don't count that). The user should also be able to change the display options to a different value of the indicator. Now he wants to show number of ID's that changed indicator from 3 to 1 between 2020-10:2020-11 and then is shown 1 (case ID 3)

I am asking for help in finding solutions. Can I do it directly in VA or should I redo the table somehow. However, I do not want to modify the task in such a way that it requires adding new columns each time data arrives. If there is a new month, December, January, etc., the report should recalculate automatically.

SAS VA 7.5

topic The direction of change over time in SAS Visual Analytics

The direction of change over time