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

[SAS_Tipster]

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.