A00-231合格させる問題集でSASInstitute24時間で試験合格できます [Q35-Q53]

A00-231合格させる問題集でSASInstitute24時間で試験合格できます

最新問題を使おうA00-231試験問題と解答でPDFで一年間無料更新

質問 # 35
The SAS data set WORK STAFF has three variables:
The following SAS program is submitted:

What is the length of the Name variable in the data set WORK STAFF_UPDATE?

A. 0
B. 1
C. 2
D. 3

正解：A

質問 # 36
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

A. The data step fails execution; there is no format for LocalFee.
B. LocalFee has format of 9. and CountryFee has a format of 7.
C. LocalFee has format of 9. and CountryFee has a format of percent7.2
D. Both LocalFee and CountryFee have a format of percent7.2

正解：D

質問 # 37
This question will ask you to provide a missing option. Given the following SAS program:

Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

A. split = '*'
B. labelsplit = '*'
C. wrap = '*'
D. label = '*'

正解：B

質問 # 38
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = 'Unknown';
else if level = 1 then
expertise = 'Low';
else if level = 2 or 3 then
expertise = 'Medium';
else
expertise = 'High';
run;
Which of the following values does the variable EXPERTISE contain?

A. Low, Medium, and High only
B. Low, Medium, and Unknown only
C. Low, Medium, High, and Unknown only
D. Low, Medium, High, Unknown, and '' (missing character value)

正解：B

質問 # 39
Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS informat correctly completes the program?

A. mondayyr10
B. ddmmyy10
C. mmddyy10
D. date9

正解：C

質問 # 40
The following SAS program is submitted:
data WORK.ONE;
Text='Australia, US, Denmark';
Pos=find (Text,'US','i',5);
run;
What value will SAS assign to Pos?

A. 0
B. 1
C. 2
D. 3

正解：B

質問 # 41
The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

A. Pass
B. . (missing numeric value)
C. Fail
D. 50.5

正解：D

質問 # 42
The following SAS program is submitted:
data work.retail;
cost = '20000';
total= .10* cost
run;
What is the result?

A. The value of the variable TOTAL in the output data set is 2000. No messages are written to the SAS log.
B. The value of the variable TOTAL in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
C. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
D. The variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.

正解：B

質問 # 43
Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

A. infile 'customer.txt' obs=1-10;
B. infile 'customer.txt' obs=10;
C. infile 'customer.txt' eof=10;
D. infile 'customer.txt' obs=10;

正解：A

質問 # 44
Which one of the following is true of the SUM statement in a SAS DATA step program?

A. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
B. It is only valid in conjunction with a SUM function.
C. It adds the value of an expression to an accumulator variable and ignores missing values.
D. It is not valid with the SET, MERGE and UPDATE statements.

正解：C

質問 # 45
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?

A. 0
B. 1
C. 2
D. 3

正解：B

質問 # 46
The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?

A. 0
B. 1
C. Undetermined, infinite loop.
D. (missing)

正解：B

質問 # 47
This question will ask you to provide a missing format:
Given the contents of the raw data file 'EMPLOYEE.TXT'

Which SAS information correctly completes the program?

A. date10
B. ddmmyy10
C. mmddyy10
D. date9

正解：C

質問 # 48
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?

A. A LIBNAME statement for the libref SASUSER only must be submitted.
B. A LIBNAME statement for the libref TEMP only must be submitted.
C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
D. No LIBNAME statement needs to be submitted.

正解：B

質問 # 49
The following SAS program is submitted:
proc contents data = sashelp.class varnum; quit;
What does the VARNUM option print?

A. the total number of variables
B. a list of variable names
C. a list of the variables in the order they were created
D. a list of the variables in alphabetic order

正解：C

質問 # 50
The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10
Which one of the following SAS programs created this data set?

A. data work.test;capacity = 150;if 100 le capacity le 200 thenairplanetype = 'Large' and staff = 10;else airplanetype = 'Small' and staff = 5;run;
B. data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff = 10;end;elsedo;airplanetype = 'Small';staff = 5;end;run;
C. data work.test;capacity = 150;if 100 le capacity le 200 thendo;airplanetype = 'Large';staff = 10;elsedo;airplanetype = 'Small';staff = 5;end;run;
D. data work.test;capacity = 150;if 100 le capacity le 200 then;airplanetype = 'Small';staff = 5;else;airplanetype = 'Large';staff = 10;run;

正解：B

質問 # 51
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?

A. The WORKTDTAL data set contains 100 observations.
B. The WORKTOTAL data set contains 500 observations.
C. The program fails to execute due to errors.
D. The WORK.TOTAL data set contains 5 observations.

正解：D

質問 # 52
The following SAS program is submitted:
data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?