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
... View more