Question

Within the data set Furn.Bookcase, the variable Finish contains values such as ash, cherry, teak, and matte-black. Which of the following creates a subset of the data in which the values of Finish contain the string walnut? Make the search for the string case-insensitive.

a.
data work.bookcase;
set furn.bookcase;
if find(Finish,'walnut',I);
run;
b.
data work.bookcase;
set furn.bookcase;
if find(Finish,'walnut','I')>0;
run;

Answer 1

To subset data based on a case-insensitive search for 'walnut' in the Finish variable, the correct SAS code uses the find function with an 'i' modifier, and checks if the result is greater than 0.

Step-by-step explanation:

To create a subset of the data where the values of Finish contain the string 'walnut' in a case-insensitive manner, we should use the SAS function find correctly to search for the substring within the variable. It is important to use the 'i' modifier to ensure the search is case-insensitive. You need to also check that the result of the find function is greater than 0 to ensure that the substring 'walnut' was indeed found inside the Finish variable's value. The correct SAS code snippet for this action is:

data work.bookcase;
set furn.bookcase;
if find(Finish,'walnut','I')>0;
run;

This code will look through all the values in the Finish variable, and whenever it finds an occurrence of the string 'walnut' (regardless of case), it will include that record in the new subset dataset named work.bookcase.