I'm looking for a way to display the amount of valid IDs per day in a line graph (using distinctive values for 'ID'). I'm on SAS VA 7.5.
So basically, when a date lies between the two date values (dtm_ing_ib_dag_code & dtm_einde_ib_dag_code) the ID is valid. I know how to do it for a specific date using parameters, but would like to see the differences over time. My idea would be to add some sort of 'dummy' calendar to the data set(not linked with the other data) and use that as my timeline. This timeline would also be used in a calculated item to determine the amount of valid IDs.
Would this be a valid solution? Any other suggestions are welcome as well of course.
I've found using the slider object on a date variable and setting the range of dates to the minimum and maximum values in the data works well. By linking the slider to the line graph you can control the date range graphed to the values chosen on the slider.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.