base的考试大部分问题都在70题上(80%-90%), 个别问题会以填空的方式考, 一般都是填一个数字,比如问sas data里有几行数据,或者循环后变量的值, 题目也在70题上,只是考试没给选项.
之前觉得base 70题里有2个题目答案有问题,今天100%通过base后,确定自己的答案应该是正确的,发上来供大家参考.
29.The following SAS program issumbitted:
data WORK.INFO;
infile 'DATAFILE.TXT';
input @1 Company $20. @25 State $2. @;
if State=' ' then input @30 Year;
else input @30 City Year;
input NumEmployees;
run;
How many raw data records areread during each iteration of the DATA step?
A. 1
B. 2
C. 3
D. 4
原始答案A, 正确答案应该是B. 在if/else的input statement之后没有"@", 因此后面NumEmployees的input会从后面一行数据读取. 所以每次data循环会读取2行数据.
45.The following SAS program issubmitted:
ods csvall file='c:\test.cvs';
proc print data=WORK.ONE;
var Name Score Grade;
by IdNumber;
run;
ods csvall close;
What is produced as output?
A. A file named test.cvs that can only beopened in Excel.
B. A text file named test.cvs that can beopened in Excel or in any text editor.
C. A text file named test.cvs that canonly be opened in a text editor.
D. A file named test.cvs that can only beopened by SAS.
原始答案C, 个人觉得答案应该是B, 输出文件是一个逗号分割符的文本文件, 虽然文件名用的是cvs而不是csv, 但是不影响Excel的读取, 比如选择打开方式后就可以在Excel中打开. 所以应该选B.