A realtor has two customers. One customer wants to view a list of homes selling for less than $60,000. The other customer wants to view a list of homes selling for greater than $100,000. Assuming the PRICE variable is numeric, which one of the following PRINT procedure steps will select all desired observations?
A. proc print data = sasuser.houses;
where price lt 60000;
where price gt 100000;
run;
B. proc print data = sasuser.houses;
where price lt 60000 or price gt 100000;
run;
C. proc print data = sasuser.houses;
where price lt 60000 and price gt 100000;
run;
D. proc print data = sasuser.houses;
where price lt 60000 or where price gt 100000;
run;
7 comments:
Answer: B
It should be C.
no it is B
C
Ans B is correct.
In Ans A, 2nd where statement overrides the first where statement and produces only observations with price more than 100k.
Ans C is wrong because where clause is out of logic.
Ans D is wrong because of syntax error.
It cannot be C because when using and both statements have to be true (i.e. price lt 60000 AND price gt 100000 at the same time) and since the price in both statements is the same, there is no possible price for which both statements is true...
B
Post a Comment