SAS Tip: Use the BETWEEN-AND Operator to Search an Inclusive Range of Values

SAS_Tipster — Fri, 06 Jul 2018 20:07:18 GMT

The BETWEEN-AND operator can be used inside of a where statement to determine if the value of a variable is contained within an inclusive range:

proc print data=sashelp.retail;
    where year between 1980 and 1984;
run;

Notice that the boundaries that you give are always included in the range, so in this case the data from 1980 and 1984 is printed, along with data from 1981-1983.

This tip was originally posted by Mary Rosenbloom on sasCommunity.org.

topic SAS Tip: Use the BETWEEN-AND Operator to Search an Inclusive Range of Values in SAS Tips from the Community

SAS Tip: Use the BETWEEN-AND Operator to Search an Inclusive Range of Values