Subsetting datasets

In many instances, we will need to select only a proportion of the overall dataset. This selection or subsetting of the dataset can be done in three ways:

• Use of the WHERE and IF statements
• Using the SAS dataset OPTIONS
• Using the DROP and KEEP statements

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...