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
