114 proc print data = sasuser.houses;
115 where price lt 60000 or price gt 100000;
NOTE: There were 6 observations read from the data set SASUSER.HOUSES.
WHERE not (price>=60000 and price<=100000);
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.09 seconds
cpu time 0.03 seconds
The correct answer is option B which has the statement, where price lt 60000 or price gt 100000;.
Option A has two WHERE statements so SAS will apply a filter according to last WHERE statement.
Option C has the statement, where price lt 60000 and price gt 100000;. The condition given will never be satisfied as no price value could be less than 60000 and greater than 1000000 at the same time. Thus, we see 0 observations in the output.
Option D has a syntax error in the WHERE statement.
The one and only FREE resource for general SAS online training as well as study guides for the SAS Base Certification. My goal is to create the SAS Certification prep guide that I never found but always wanted. This should also be a place to come if you are new to the language but are simply looking for online SAS training.