Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - More on the WHERE Expression/Statement

The video tutorial explains the use of the WHERE expression for subsetting data, highlighting its advantages over the IF-THEN statement. It covers the basic syntax and demonstrates its application in PROC SQL, as a data set option, and in both data and PROC steps. The WHERE expression is efficient as it doesn't create a new data set when used in procedures, making it a preferred choice for subsetting.

What is one advantage of using the WHERE expression over the IF-THEN statement?

• It is more readable.

• It requires less memory.

• It is easier to write.

• It can be used in PROC steps.

In which scenario does the WHERE statement not create a new dataset?

• When used in a macro.

• When used with IF-THEN logic.

• When used in PROC SQL.

• When used in a DATA step.

Which of the following is a correct syntax for using the WHERE statement in PROC SQL?

• proc sql; select total from sales and total > 50;

• proc sql; select total from sales when total > 50;

• proc sql; select total from sales if total > 50;

• proc sql; select total from sales where total > 50;

How can the WHERE statement be used as a data set option?

• By using it in the SELECT clause.

• By including it in parentheses after the dataset name.

• By using it in the PRINT statement.

• By placing it before the dataset name.

Which method allows the WHERE statement to be used in both data and PROC steps?

• Using it only in the DATA step.

• Using it as a data set option.

• Including it in both data and PROC steps.

• Using it only in PROC SQL.