Hands-On SAS for Data Analysis

WHERE and IF statements

Let's only select the data where the records have been updated in 2019:

DATA Updated_2019;SET Cost_Living;WHERE Year(Updated) = 2019;RUN;

The following output will be generated:

In this instance, we could have also used the IF statement to generate similar output. We can also use WHERE and IF statements in the same data step:

DATA Updated_2019;SET Cost_Living;WHERE Year(Updated) = 2019;IF Index >= 80; RUN;

This further subsets the data and produces the following output:

While subsetting, we should be aware of whether ...