[2024年更新]A00-231まとめセット試験ガイド練習からあなたのA00-231試験を合格させます！ [Q27-Q48]

[2024年更新]A00-231まとめセット試験ガイド練習からあなたのA00-231試験を合格させます！

準備A00-231試験2024年最新のSAS Institute Systems無制限298問題

SASInstitute A00-231試験は、SAS 9.4 Baseプログラミングにおける個人の知識とスキルを評価するパフォーマンスベースの評価です。この試験は、SASプログラミングとデータ分析の熟練度を証明したい個人を対象としています。試験は、SASプログラミングの概念の実践的な適用を試験するシミュレートされた環境で実施されます。

試験は、データ操作、データ分析、レポーティング、プログラミングの基礎など、さまざまなトピックから構成されています。候補者はまた、SAS手順や関数、マクロプログラミング、プログラムのデバッグについての知識も試験されます。試験は、多肢選択問題、シナリオベースの問題、コーディング演習の組み合わせに基づいています。

試験はオンラインで実施され、世界中のどこからでも撮影できます。試験期間は2時間30分で、候補者はパフォーマンスベースの質問のセットを解決する必要があります。この試験には、英語、フランス語、ドイツ語、日本語、スペイン語など、複数の言語があります。

 

質問 # 27
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?

• A. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.
• B. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.
• C. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.
• D. The by statement in the DATA step causes a syntax error.

正解：B

質問 # 28
Which one of the following is true when SAS encounters a data error in a DATA step?

• A. A note appears in the SAS log that the incorrect data record was saved to a separate SAS file for further examination.
• B. The DATA step stops executing at the point of the error, and the resulting DATA set contains observations up to that point.
• C. A note is written to the SAS log explaining the error, and the DATA step continues to execute.
• D. The DATA step stops executing at the point of the error, and no SAS data set is created.

正解：C

質問 # 29
The contents of the raw data file CALENDAR are listed below:
--------10-------20-------30
01012000
The following SAS program is submitted:
data test;
infile 'calendar';
input @1 date mmddyy10.;
if date = '01012000'd then event = 'January 1st';
run;
Which one of the following is the value of the EVENT variable?

• A. The value can not be determined as the program fails to execute due to errors
• B. . (missing numeric value)
• C. 01012000
• D. January 1st

正解：A

質問 # 30
The following SAS program is submitted:

How many observations are written to the WORK.SALES data set?

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

正解：A

質問 # 31
Given the SAS data set WORK. PRODUCTS:

The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns); Revenue-Price* (Sales-Returns); run; How many variables does the WORK.REVENUE data set contain?

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

正解：A

質問 # 32
When SAS encounters a data when reading from a raw data file, which action will occur?

• A. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
• B. SAS will write a NOTE to the SAS log and continue execution.
• C. SAS will write a WARNING message to the SAS log and suspend execution.
• D. SAS will write an ERROR message to the SAS log and suspend execution.

正解：A

質問 # 33
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:

The following program is submitted:

Which statement should be inserted to produce the following output?

• A. Qtr1 = month{1} + month{2} + month {3};
• B. Qtr1 = sum(of month{_ALL_});
• C. Qtr1 = sum(of month {*});
• D. Qtr1 = sum(of month {3});

正解：C

質問 # 34
The following SAS program is submitted:

The SAS data set WORK.SALARY is currently ordered by Gender within Department.
Which inserted code will accumulate subtotals for each Gender within Department?

• A. Department
• B. Gender
• C. Department Gender
• D. Gender Department

正解：B

質問 # 35
Given the SAS data set QTR 1_REVENUE:
destination revenue
YYZ53634
FRA62129
FRA75962
RDU76254
YYZ82174
The following SAS program is submitted:
proc sort data = qtr1_revenue;
by destination descending revenue; run;
What is the first observation in the output data set?

• A. destination revenue YYZ 53634
• B. destination revenue FRA 75962
• C. destination revenue FRA 62129
• D. destination revenue YYZ 82174

正解：B

質問 # 36
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 variable TOTAL in the output data set has no value. The program fails to execute due to a syntax error.
• C. 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.
• D. The value of the variable TOTAL in the output data set is missing. An error message is written to the SAS log.

正解：C

質問 # 37
The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?

• A. to the SAS output window or to an output file
• B. to the raw data file that was most recently opened
• C. to the SAS log
• D. to the SAS data set _NULL_

正解：C

質問 # 38
Given the following raw data records:

The following output data set is desired:

Which SAS program correctly reads in the raw data?

• A. data employees; infile 'file specification'dlm='*'; input employee $ bdata: mmddyy10.years; run;
• B. data employees; infile 'file specification' dLM='*' dsd; input employee $ bdata: mmddyy10.years; run;
• C. data employees; infile 'file specification'dsd='*'; input employee $ bdata mmddyy10.years; run;
• D. data employees; infile 'file specification'DLM dsd; input employee $ bdata mmddyy10.years; run;

正解：B

質問 # 39
A raw data file is listed below:
--------10-------20-------30
squash 1.10
apples 2.25
juice 1.69
The following SAS program is submitted using the raw data file above:
data groceries;
infile 'file-specification';
input item $ cost;
run;
Which one of the following completes the program and produces a grand total for all COST values?

• A. grandtot = sum cost;
• B. retain grandtot 0;grandtot = sum(grandtot,cost);
• C. grandtot = sum(grandtot,cost);output grandtot
• D. grandtot = sum(grandtot,cost);

正解：B

質問 # 40
Given the SAS data set ONE:
ONE
ObsDte
-------------
109JAN2005
212JAN2005
The following SAS program is submitted:
data two;
set one;
day = <insert expression here>;
format dte date9.;
run;
The data set TWO is created:
TWO
ObsDteDay
109JAN20051
12JAN20054
Which expression successfully completed the program and created the variable DAY?

• A. weekday(dte)
• B. day(dte)
• C. dayofweek(dte)
• D. datdif(dte,'01jan2005'd,'act/act')

正解：A

質問 # 41
Scenario:
This project will use data setcert.input36. At any time, you may save your program asprogram36 in cert\programs. Write a SAS program that will clean the data incert.input36as follows:
Step 1:
create a temporary data set, cleandata36.
In this data set, convert all case.
Then keep only observations with group equal to 'A' or 'B'.
Step 2:
Determine the MEDIAN value for the Kilograms variable for each group(A,B) in the cleandata36 data set. Round MEDIAN to the nearest whole number.
Step 3:
* Create results.output36 from cleandata36
* Ensure that all values for variable Kilogramsare between 40 and 200, inclusively.
* If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respectivegroup(A,B) calculated in step 2 What is the MEAN Kilograms value for group='A' in the results.output36 data set?

正解：

解説：
76.3

質問 # 42
Given the AIRPLANES data set
AlRPLANES
TYPE MPG
-------- ------
F-18 105
C-130 25
Harrier 75
A-6 110
The following SAS program is submitted:
data gt100;
set airplanes(keep = type mpg load);
load = mpg * 150;
run;
The program fails to execute due to syntax errors.
What is the cause of the syntax error?

• A. LOAD must be defined prior to the SET statement.
• B. LOAD is not variable in the data set AIRPLANES.
• C. LOAD is not a variable in the data set GT100.
• D. MPG is not a numeric variable.

正解：B

質問 # 43
Which statement about SAS libraries is true? Select one:

• A. At the end of each session, SAS deletes the contents of all SAS libraries.
• B. A SAS library is a collection of one or more SAS files that are referenced and stored as a unit.
• C. You refer to a SAS library by a logical name called a lib name.
• D. A single SAS library must contain files that are stored in different physical locations.

正解：B

質問 # 44
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. ddmmyyyy10.
• C. date9.
• D. ddmmyy10.

正解：D

質問 # 45
Given the following data step:

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

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

正解：C

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

Which procedure output will appear in test.html?

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

正解：D

質問 # 47
Given the SAS data set EMPLOYEE INFO:
EMPLOYEE_INFO
IDNumber
Expenses
2542
100.00
3612
133.15
2198
234.34
2198
111.12
The following SAS program is submitted:
proc sort data = employee_info;
<insert BY statement here>
run;
Which BY statement completes the program and sorts the data sequentially by ascending expense values within each ascending IDNUMBER value?

• A. by IDNumber Expenses;
• B. by ascending IDNumber ascending Expenses;
• C. by Expenses IDNumber;
• D. by ascending Expenses IDNumber;

正解：A

質問 # 48
......

注目のA00-231まとめセット試験ガイドは最速合格できます：https://jp.fast2test.com/A00-231-premium-file.html

練習するA00-231にはFast2test明確な練習であなたをSAS 9.4 Base Programming - Performance-based exam試験合格させます：https://drive.google.com/open?id=1b-oZdyi7AOygluL2a0Ns7NxH2WMcZ-f3