[2022年更新]A00-211回答無料デモは最適で最高のリアルな試験合格させます [Q86-Q105]

[2022年更新]A00-211回答無料デモは最適で最高のリアルな試験合格させます

A00-211[2022年10月最新推薦]試験問題はあなたをパスさせる

SASInstitute A00-211 認定試験の出題範囲：

トピック	出題範囲
トピック 1	基本SAS手順を使用して要約レポートと度数分布表を生成プログラミングロジックエラーを特定して解決する
トピック 2	Excelワークブックへのアクセス SAS日付値の作成と操作
トピック 3	データ構造へのアクセスと作成一時的および永続的なSASデータセットの作成
トピック 4	ODSステートメントを使用したレポートの生成構文エラーの認識と修正データエラーの調査と解決
トピック 5	データをエクスポートして、標準およびカンマ区切りの生データファイルを作成します
トピック 6	SASデータセット内の観測値を並べ替える SASステートメントを条件付きで実行する
トピック 7	SAS関数を使用して文字データを数値に変換したりその逆を行ったりする
トピック 8	DOLOOPSを使用したデータの処理 PRINTプロシージャを使用したリストレポートの生成
トピック 9	SAS関数を使用して文字データ、数値データ、およびSAS日付値を操作する
トピック 10	ユーザー定義のフォーマット、タイトル、脚注、SASシステムレポートを使用してレポートを強化する
トピック 11	DATAステップのオプションとステートメントを使用して変数属性を変更する
トピック 12	DATAステップステートメントを使用して小計と合計を累積する

質問 86
The following code was modified to generate the results further below:

The following results were generated to display only specific statistics and limit the decimals with the modification:

Which statement below was modified or added to generate the results above?

A. var Height / nobs min max mean maxdec=1;
B. output nobs min max mean maxdec=1;
C. proc means data=SASHELP.CLASS maxdec=1 ;
D. proc means data=SASHELP.CLASS min max mean maxdec=1;

正解: D

解説:
Section: Volume A

質問 87
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?

A. proc print data=MYXLS.NORTH;
run;
B. proc print data=MYXLS.'NORTH'e;
run;
C. proc print data=MYXLS.'NORTH$'n;
run;
D. proc print data=MYXLS.NORTH$;
run;

正解: C

質問 88
Given the SAS data set WORK.PRODUCTS:

How many variables does the WORK.REVENUE data set contain?

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

正解: D

質問 89
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;
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;

正解: D

質問 90
Consider the data step:

Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?

A. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
B. where Age not between 15 and 16 then Group=1; else Group=2;
C. both A or C will work.
D. if Age not in(15,16) then Group=1; else Group=2;

正解: D

質問 91
The Excel workbook REGIONS.XLSX contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS pcfiles path='c:\regions.xlsx';
Which PROC PRINT step correctly displays the NORTH worksheet?

A. proc print data=MYXLS.NORTH.XLS;run;
B. proc print data=MYXLS.'NORTH'e;run;
C. proc print data=MYXLS.'NORTH$'n;run;
D. proc print data=MYXLS.NORTH$;run;

正解: C

質問 92
The following SAS program is submitted:
data one;
date = '04juI2005'd;
format date weekdate.; run;
proc print data = one; run;
What output is generated?

A. Obs date 1 Monday, 07/04/2005
B. Obs date 1 04Jul2005
C. Obs date 1 July4, 2005
D. Obs date 1 Monday, July 4, 2005

正解: D

質問 93
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?

A. An error on the INPUT statement specification for reading the variable Salary.
B. The 1st of potentially many errors, this one occurring on the 4th observation.
C. An execution error, triggered by an invalid character for the variable Salary.
D. A compiler error, triggered by an invalid character for the variable Salary.

正解: C

解説:
Section: Volume B

質問 94
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 a grand total of NUMBER.
C. Nothing is produced by the SUM statement; the program fails to execute.
D. The SUM statement produces only subtotals of NUMBER for each value of TYPE.

正解: B

質問 95
The following SAS program is submitted:
data work.pieces;
do while (n lt 6);
n + 1;
end;
run;
Which one of the following is the value of the variable N in the output data set?

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

正解: B

質問 96
After a SAS program is submitted, the following is written to the SAS log:

What issue generated the error in the log?

A. The syntax of the drop statement does not use an equals sign.
B. There should have been commas between the variable names.
C. A drop statement and a keep= data set option cannot both be used at the same time.
D. The list of variables should have been enclosed in parentheses.

正解: C

解説:
Section: Volume B
Explanation/Reference:
Reference http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/ viewer.htm#a000202902.htm

質問 97
Given the SAS data set PRICES:
PRICES prodid price K12S5.10producttype NETWORKsales 15returns
B132S 2.34HARDWARE30010 R18KY21.29SOFTWARE255 3KL8BY 6.37HARDWARE12515 DY65DW 5.60HARDWARE455 DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;
How many observations does the HWARE data set contain?

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

正解: D

質問 98
Given the following data step:

After data step execution, what will data set WORK.GEO contain?

A. Option B
B. Option A
C. Option C
D. Option D

正解: B

質問 99
The following SAS DATA step is submitted:
libname temp 'SAS-data-library';
data temp.report;
set sasuser.houses;
newvar = price * 1.04;
run;
Which one of the following statements is true regarding the program above?

A. The program is reading from a temporary data set and writing to a permanent data set.
B. The program is reading from a permanent data set and writing to a permanent data set.
C. The program is reading from a temporary data set and writing to a temporary data set.
D. The program is reading from a permanent data set and writing to a temporary data set.

正解: B

質問 100
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:

What does it mean?

A. An error on the INPUT statement specification for reading the variable Salary.
B. The 1st of potentially many errors, this one occurring on the 4th observation.
C. An execution error, triggered by an invalid character for the variable Salary.
D. A compiler error, triggered by an invalid character for the variable Salary.

正解: C

質問 101
The following SAS program is submitted:
data allobs;
set sasdata.origin (firstobs = 75 obs = 499);
run;
The SAS data set SASDATA.ORIGIN contains 1000 observations.
How many observations does the ALLOBS data set contain?

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

正解: B

質問 102
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, <=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?

A. (drop=Month, Quantity, Cost)
B. (drop Month, Quantity, Cost)
C. (drop Month Quantity Cost)
D. (drop=Month Quantity Cost)

正解: C

質問 103
The following SAS program is submitted:
libname temp 'SAS data library';
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005. What output is produced if April 15, 2005 falls on a Friday?