Hi,
in sas VA,
-the filter n Between inclusive (4,5) it means: n <=5 and n>=4
-the filter n OutsideExclusive(4,4) it means: n <4 and n >4
is it right?
Hello,
Your understanding is correct. The documentation for these two operators is:
BetweenInclusive
returns true if the first value is within the range defined by the second and third values (including the bounding values).
For example, X BetweenInclusive(50, 100)
returns true if X is greater than or equal to 50 and less than or equal to 100.
OutsideExclusive
returns true if the first value is outside the range defined by the second and third values (excluding the bounding values).
For example, X OutsideExclusive(50, 100)
returns true if X is less than 50 or greater than 100.
Not (BetweenInclusive)
.
Hello,
Your understanding is correct. The documentation for these two operators is:
BetweenInclusive
returns true if the first value is within the range defined by the second and third values (including the bounding values).
For example, X BetweenInclusive(50, 100)
returns true if X is greater than or equal to 50 and less than or equal to 100.
OutsideExclusive
returns true if the first value is outside the range defined by the second and third values (excluding the bounding values).
For example, X OutsideExclusive(50, 100)
returns true if X is less than 50 or greater than 100.
Not (BetweenInclusive)
.
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.