标题: question about SAS certificate practice exam [打印本页] 作者: shiyiming 时间: 2006-10-10 04:02 标题: question about SAS certificate practice exam C:\Documents and Settings\Jerry\Local Settings\Temp\Temporary Directory 8 for SASCert_BaseProgramming_Memo.zip\M04 - Creating List Reports - 54 of 55.mht
quesiton 9: I think both answer a and c are correct.
Do you guys have second thought?
Thanks a lot,
jerrywu作者: shiyiming 时间: 2006-10-10 04:04 标题: the question 9 The question is:
9. Choose the statement below that selects rows in which
the amount is less than or equal to $5000
the account is 101-1092 or the rate equals 0.095.
a. where amount <= 5000 and account='101-1092' or rate = 0.095;
b. where (amount le 5000 and account='101-1092') or rate = 0.095;
c. where amount <= 5000 and (account='101-1092' or rate eq 0.095);
d. where amount <= 5000 or account='101-1092' and rate = 0.095;
I think answer a and c are both correct.作者: shiyiming 时间: 2006-11-3 12:08 标题: I think only c is correct since for a, if rate=0.095; or both the other two conditions satisfied, it will be selected. But for c, you must satisfied amount<=500 and rate=0.095 both or satisfied amount<=500 and account='101-1092'.