Question 34: You have been given below dataset

 You need to process the dataset which has either MUMBAI or AHMEDABAD as a location and fee is higher than 500, which of the following statement is correct for this?

1.          if fee=5000 and location NOT in ('MUMBAI' ,'AHMEDABAD');
2.        Get all Questions and Answer from here
3. You need to have paid subscription to access all questions
4. Thanks for considering SAS Certification Material

 Correct Answer : 3 Exp : To filter the data you can use if statement. However, you should be aware how the operators can be used. In this case IN clause will help you to filter the records which only satisfy the one of the condition in parenthesis.

You can access to full explanation to question and answer from this page.