A00-212 Exam QuestionsBrowse all questions from this exam

A00-212 Exam - Question 14


This question will ask you to provide a segment of missing code.

Given the following program and data:

What is the WHERE statement that successfully completes the PROC PRINT and selects the observation from Barb?

Show Answer
Correct Answer: AD

In SAS, when using macro variables in a WHERE statement and the target variable is a date, it is necessary to use the appropriate syntax to handle the macro variable correctly. The correct format for this is to add 'd' to tell SAS to treat the result as a SAS date. Thus, the correct WHERE statement would be 'Birthday=&"Want" d;'. This ensures that the Birthday variable is compared correctly with the date value stored in the macro variable Want.

Discussion

2 comments
Sign in to comment
psreddy
Jun 10, 2019

there is no correct answer given

SugarlipsOption: B
Nov 21, 2019

"&Want"d is the answer