究極のガイド準備A00-231認証試験SAS Institute Systemsは2023年更新
リアルA00-231問題集でSASInstitute正確なアンサーは最新問題は2023年更新
質問 125
The following SAS program is submitted:
What is the result?
- A. The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.
- B. The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.
- C. The variable Discount in the output data set is set to zero. No messages are written to the SAS log.
- D. The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.
正解: B
質問 126
The following SAS program is submitted;
data combine;
country = 'Italy, Russia, ireland';
found = find(country, 'i');
run;
What is the value of the variable FOUND in the output data set?
- A. Italy
- B. 0
- C. Russia
- D. 1
正解: D
質問 127
The following program is submitted:
proc contents data=_all_;
Which statement best describes the output from the submitted program?
- A. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- B. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.
- C. The output displays only a list of the SAS data sets that are contained in the WORK library.
- D. The output displays only the contents of the SAS data sets that are contained in the WORK library.
正解: B
質問 128
Which ODS statement option terminates output being written to an HTML rile?
- A. CLOSE
- B. END
- C. STOP
- D. QUIT
正解: A
質問 129
After a SAS program is submitted, the following is written to the SAS log:
What issue generated the error in the log?
- A. There should have been commas between the variable names.
- B. The syntax of the drop statement does not use an equals sign.
- C. The list of variables should have been enclosed in parentheses.
- D. A drop statement and a keep= data set option cannot both be used at the same time.
正解: D
質問 130
The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
正解: C
質問 131
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?
- A. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.
- B. The data set WORK.TEST is stored in ascending order by values of the NAME variable.
- C. The data set WORK.TEST is stored in descending order by values of the NAME variable.
- D. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
正解: D
質問 132
The following SAS program is submitted:
data work.month;
date = input('13mar2000',date9.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
- A. character, 9 bytes
- B. numeric, 9 bytes
- C. character, 8 bytes
- D. numeric, 8 bytes
正解: D
質問 133
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obsstylebedroomsbathspricesqteetstreet
1CONDO21.5800501200MAIN
2CONDO32.5793501300ELM
3CONDO42.51271501400OAK
4CONDO22.01107001100FIFTH
5TWOSTORY43.01072502100SECOND
6TWOSTORY21.0556501600WEST
7TWOSTORY21.0692501450NORTH
6TWOSTORY42.5102950 2000SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
- style price
- CONDO$79,700
- TWOSTORY$62550
Which DEFINE statement completes the program and produces the desired output?
- A. define style / display width = 9;
- B. define style / group width = 9;
- C. define style / width = 9,
- D. define style / order width = 9;
正解: B
質問 134
A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx. Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?
- A. A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
- B. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
- C. The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
- D. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
正解: D
質問 135
The following SAS program is submitted:
data numrecords;
infile 'file specification';
input@1 patient $15. relative$ 16-26@;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15. clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step execution?
- A. 0
- B. 1
- C. 2
- D. 3
正解: A
質問 136
The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?
- A. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
- B. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
- C. The SUM statement produces only a grand total of NUMBER.
- D. Nothing is produced by the SUM statement; the program fails to execute.
正解: C
質問 137
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 variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
- D. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.
正解: B
質問 138
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:
WORK.EMPLOYEE WORK.SALARY
fname age name salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the FNAME variable?
- A. merge work.employeework.salary (rename = (name = fname));
- B. merge work.employeework.salary (rename = (fname = name));
- C. merge work.employeework.salary (name = fname);
- D. merge work.employeework.salary (fname = name);
正解: A
質問 139
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
正解: D
質問 140
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = 'Jan' then output january;
108 sales = cost * num_sold;
109 keep = product sales;
------
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
- A. keep = product, sales;
- B. keep = (product sales);
- C. keep product sales;
- D. keep product, sales;
正解: C
質問 141
......
SAS Institute Systems A00-231試験練習問題集：https://jp.fast2test.com/A00-231-premium-file.html
A00-231プレミアム資料テストPDFで無料問題集お試しセット：https://drive.google.com/open?id=1b-oZdyi7AOygluL2a0Ns7NxH2WMcZ-f3