Hi,
Good day!
Anyone here know how to remove the last tie value in rank SAS VA? For example, Top 5 (see below sample data). User want to exclude the ties in TOP5, so we unticked the "all ties" option so our expectations was "F" will be removed but instead of F it was C.
Sample Data:
Name Count
A 4
B 4
C 2
D 2
E 2
F 2
Expectations: Top 5
Name Count
A 4
B 4
C 2
D 2
E 2
Reality (Result): Top 5
Name Count
A 4
B 4
D 2
E 2
F 2
Thank you.
Best Regards,
Carrot17
Hi @Carrot17,
sorry for the late reply....
In my knowledge there is no workaround for this in SAS VA.
In simple form Tie option will work based on Alphabetical order (i.e., if you un-check the TIE for TOP Level it will remove/hide C, in the same way if you un-check the TIE for Bottom Level it will remove/hide B. )
Ex:
Actual Data:
Name Count
A 4
B 4
C 2
D 2
E 2
F 2
For Top 5:
Name Count
A 4
B 4
D 2
E 2
F 2
For Bottom 5:
A 4
C 2
D 2
E 2
F 2
Thanks,
Teja Surapaneni
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.