A00-231のPDF問題集リアル2023最近更新された問題 [Q111-Q130]

A00-231のPDF問題集リアル2023最近更新された問題

リリースSASInstitute A00-231更新された問題PDF

Sasinstitute A00-231認定試験は、SASプログラミングを使用して複雑な問題を解決する候補者の能力を評価するために設計されたさまざまなタスクで構成されています。この試験では、データ操作、データ分析、レポート生成など、幅広いトピックをカバーしています。候補者は、効率的かつ効果的なSASコードを作成し、SASプログラムを解釈およびデバッグし、SAS出力を使用してレポートを作成する能力を実証することが期待されています。この試験では、SASデータセットを操作し、SAS変数を作成および変更し、SAS手順を使用してデータを分析する候補者の能力もテストします。この試験に合格することは、データ分析、ビジネスインテリジェンス、またはSASプログラミングに取り組みたい個人にとって貴重な資格です。

 

質問 # 111
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 ascending 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 descending order by values of the NAME variable.

正解：A

質問 # 112
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?

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

正解：B

質問 # 113
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 WORK.TOTAL data set contains 5 observations.
• B. The WORKTDTAL data set contains 100 observations.
• C. The WORKTOTAL data set contains 500 observations.
• D. The program fails to execute due to errors.

正解：A

質問 # 114
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

質問 # 115
The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?

• A. of
• B. Dickens
• C. '' (missing character value)
• D. T

正解：C

質問 # 116
A raw data file is listed below:
RANCH,1250,2,1, Sheppard Avenue,"$64,000"
SPLIT,1190,1,1, Rand Street,"$65,850"
CONDO,1400,2,1.5, Market Street,"80,050"
TWOSTORY,1810,4,3, Garris Street,"$107,250"
RANCH,1500,3,3, Kemble Avenue,"$86,650"
SPLIT,1615,4,3, West Drive,"94,450"
SPLIT,1305,3,1.5, Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH';
input sqfeet bedrooms baths street $
price: dollar10.;
run;
How many observations will the output data set contain?

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

正解：D

質問 # 117
The following output is created by the FREQUENCY procedure:

Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?

• A. norowcount nocolcount
• B. norow nocol
• C. nocounts
• D. freq percent

正解：B

質問 # 118
The following SAS program is submitted once:

Which procedure output will appear in test.html?

• A. Both the PRINT procedure and FREQ procedure output
• B. Only the FREQ procedure output
• C. Only the PRINT procedure output
• D. No procedure output due to syntax errors

正解：D

質問 # 119
The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?

• A. SASUSER
• B. WORK
• C. REPORT.
• D. HOUSES

正解：B

質問 # 120
Given the contents of the raw data file EMPLOYEE:
----|----10----|----20----|----30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile 'employee';
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?

• A. ddmmyyyy9.
• B. ddmmyy10.
• C. date9.
• D. ddmmyyyy10.

正解：B

質問 # 121
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. No LIBNAME statement needs to be submitted.
• C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
• D. A LIBNAME statement for the libref TEMP only must be submitted.

正解：D

質問 # 122
Given the SAS data set WORK.ONE:

And the SAS data set WORK.TWO:

The following program is submitted:

What is the first observation in the SAS data set WORK.BOTH?

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

正解：B

質問 # 123
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?

• A. 0
• B. 1
• C. 2
• D. (missing numeric value)

正解：A

質問 # 124
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 overwrite the outdata worksheet in the exceldata.xlsx workbook.
• C. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
• D. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.

正解：D

質問 # 125
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode='Job Description';
run;
Which statement is true about the output dataset?

• A. The label of the variable Jobcode is Job Description.
• B. The program fails to execute due to errors. Labels must be defined in a PROC step.
• C. The label of the variable Jobcode is Job (only the first word).
• D. The label of the variable Jobcode is Job Desc (only the first 8 characters).

正解：A

質問 # 126
Consider the following data step:
data WORK.NEW;
set WORK.OLD;
Count+1;
run;
The varaible Count is created using a sum statement.
Which statement regarding this variable is true?

• A. It is assigned a value of missing when the data step begins execution.
• B. It is assigned a value 0 at compile time.
• C. It is assigned a value of missing at compile time.
• D. It is assigned a value 0 when the data step begins execution.

正解：B

質問 # 127
The following SAS program is submitted:
data work.new;
mon = 3;
day = 23;
year = 2000;
date = mdy(mon,day,year);
run;
Which one of the following is the value of the DATE variable?

• A. a character string with the value '23mar2000'
• B. a character string with the value '03/23/2000'
• C. a numeric value of 3232000, which represents the SAS date value for March 23, 2000
• D. a numeric value of 14692, which represents the SAS date value for March 23, 2000

正解：D

質問 # 128
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

正解：A

質問 # 129
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY
name age name salary
Bruce 30 Bruce 40000
Dan 35 Bruce 35000
Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?

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

正解：D

質問 # 130
......

A00-231問題集と練習テスト（265試験問題)：https://www.jpntest.com/shiken/A00-231-mondaishu