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.
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?
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?
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.