SASBase认证考试—70题（61-70）_原创文档.pdfVIP

SASBase认证考试—70题（61-70）

SASBase认证考试—70题(61-70)

Q61

Considerthedatastep:

dataWORK.TEST;dataWORK.TEST;

inputNameSexAgeHeightWeight;

ifAgeNE16andAgeNE15thenGroup=1;

elseGroup=2;

run;

Whichstatementproducesafunctionallyequivalentresult

forassigningGroupavalue?

A.ifAgenotin(15,16)thenGroup=1;elseGroup=2;

B.if(AgeNE16)or(AgeNE15)thenGroup=1;elseGroup=2;

C.whereAgenotbetween15and16thenGroup=1;else

Group=2;

D.bothAorCwillwork.

答案：A

本题知识点：IF语句、IN的使用

参考第17题。

Q62

ThefollowingSASprogramissubmitted:

_insert_ods_code_

procmeansdata=SASUSER.SHOES;

whereProductin(Sandal,Slipper,Boot);

run;

_insert_ods_code_

WhichODSstatements,insertedinthetwolocationsabove,

createareportstoredinanhtmlfile?

A.odshtmlopen=sales.html;

odshtmlclose;

B.odsfile=sales.html/html;

odsfileclose;

C.odshtmlfile=sales.html;

odshtmlclose;

D.odsfilehtml=sales.html;

odsfileclose;

答案：C

本题知识点：PROCCOTENTS过程

ODS的主要输出目标：LISTING、RESULTS、OUTPUT、HTML、

CSVALL、RTF、PDF、其他。ODSHTML适用于数据较少的数据集、

或汇总的数据集，如TABULATE过程。

Q63

ThefollowingSASprogramissubmitted:

dataWORK.OUTDS;

dountil(ProdGT6);

Prod+1;

end;

run;

WhatisthevalueofthevariableProdintheoutputdataset?

A..(missing)

B.6

C.7

D.Undetermined,infiniteloop.

答案：C

本题知识点：WHERE语句

参考第40题。

Q64

ThefollowingSASprogramissubmitted:

datawork.accounting;

lengthjobcode$12;

setwork.department;

run;

TheWORK.DEPARTMENTSASdatasetcontainsacharacter

variablenamedJOBCODEwithalengthof5.