SASInstitute A00-231 問題集

質問 1：
The following SAS program is submitted:
Data WORK.COMPRESS;
ID = '1968 05-10 567';
NewID = compress (ID, "-");
run;
What will the value of NewID be in the WORK.COMPRESS data set?
A. 196805-10567
B. 1968 0510 567
C. 19680510567
D. 1968 05-10 567
正解：D

質問 2：
This question will ask you to provide a segment of missing code.
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

The data set WORK.TWO is created, where Day would be the day of the month:

Which expression successfully completed the program and creates the variable Day?
A. day(BeginDate)
B. getday(BeginDate)
C. weekday(BeginDate)
D. dayofmonth(BeginDate)
正解：C

質問 3：
The following SAS program is submitted:

How will the Exam variable value be displayed in the FREQ procedure output?
A. Pass
B. 50.5
C. .(missing numeric value)
D. Fail
正解：B

質問 4：
A PROC PRINT report was created with the following title:
Asia Sports Vehicle Summary After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title: Asia Sports Vehicle Summary Distribution by Make Which statement(s) would produce the new report titles?
Select one:
A. title "Asia Sports Vehicle Summary"; title "Distribution by Make";
B. title "Asia Sports Vehicle Summary"; subtitle "Distribution by Make";
C. title "Asia Sports Vehicle Summary"; title2 "Distribution by Make";
D. title "Distribution by Make";
正解：C

質問 5：
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:

The following SAS program is submitted:

Which report is produced?

A. Option A
B. Option C
C. Option D
D. Option B
正解：D

質問 6：
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
A. The _ERROR_ variable contains the number of the observation that caused the data error.
B. The _ERROR_ variable can be used in expressions in the DATA step.
C. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
D. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
正解：B

質問 7：
Given the raw data file EMPLOYEE.TXT:

The following SAS program is submitted:

What value does the variable idnum contain when the name of the employee is "Ruth"?
A. 44
B. 33
C. 39
D. 22
正解：D

質問 8：
This question will ask you to provide a line of missing code.
The following SAS program is submitted:
proc freq data = WORK.SALES;
<insert code here>
run;
The following output is created by the FREQUENCY procedure:

Which statement was used to complete the above program that produced the output?
A. tables region product;
B. var region * product;
C. tables region*product;
D. var region product;
正解：C

質問 9：
The following SAS program is submitted:
data work.test;
set work.staff (keep = jansales febsales marsales);
array diff_sales{3} difsales1 - difsales3;
array monthly{3} jansales febsales marsales;
run;
What new variables are created?
A. DIFF_SALES1, DIFF_SALES2 and DIFF_SALES3
B. JANSALES, FEBSALES and MARSALES
C. DIFSALES1, DIFSALES2 and DIFSALES3
D. MONTHLY1, MONTHLY2 and MONTHLY3
正解：C