Hi,
Can someone tell me How can i achieve following Results :
I need to show the delta records which mean when i click on 22 it will display 25 -22 =3 records.
The issue is here that when i use slider i wont allow me to drill down missing values.
Hello,
Can you give us some more details about what you want to calculate?
Do you want to calculate the difference between Sch and Act? Do you want to calculate the difference between each cell and the one above it in the table? Do you want to calculate something based on a date variable?
It is not clear how the slider control is related to your crosstab.
Finally, can you tell us which version of VA are you using?
Thanks,
Sam
Are you saying that you can't assign a date variable to a slider if the date variable contains missing values?
I don't have a good data set handy to test this, but I could try to create one if you can confirm that is the issue.
Ahh! I see. For the objects that are filtered by the date slider, you don't see any values where the date is missing.
I'm not sure how to work around this, unfortunately.
Do you have the other part of your question resolved, calculating the difference between act and sch?
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.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.