オンラインA00-231テストブレーン問題集とテストエンジン
リアルSASInstitute A00-231試験問題集には正解298問題と解答があります
Sasinstitute A00-231認証試験は、パフォーマンスベースの試験です。これは、試験が現実世界のシナリオで候補者のスキルをテストするように設計されていることを意味します。候補者は、仕事で遭遇するタスクと同様のタスクを実行する必要があります。このテストへのアプローチにより、候補者は現実世界のシナリオに十分に準備され、スキルを効果的に適用できるようになります。
質問 # 62
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. ddmmyy10.
- B. ddmmyyyy10.
- C. ddmmyyyy9.
- D. date9.
正解:A
質問 # 63
CORRECT TEXT
This question will ask you to provide a line of missing code:
Given the SAS data set WORK.EMPLOYEE_UNFO:
The following SAS program is submitted:
In the space above, write the statement that will sort the data by ascending Expenses values within each ascending IDNumber value.
正解:
解説:
byIDNumberExpenses;IDNumberExpenses2542100.003612133.152198234.342198111.12
質問 # 64
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
- A. Option A
- B. Option D
- C. Option B
- D. Option C
正解:D
質問 # 65
The following SAS program is submitted:
data WORK.AUTHORS;
array Favorites{3} $ 8 ('Shakespeare','Hemingway','McCaffrey');
run;
What is the value of the second variable in the dataset WORK.AUTHORS?
- A. '' (a missing value)
- B. Hemingway
- C. Hemingwa
- D. The program contains errors. No variables are created.
正解:C
質問 # 66
What describes the SAS automatic _ERROR_ variable?
- A. The _ERROR_ variable can be used in expressions or calculations in the DATA step.
- B. The ERROR_variable contains the number or the observation that caused the error.
- C. The _ERROR_ variable contains the values 'TRUE' or 'FALSE.'
- D. The _ERROR variable maintains a count of the number of data errors.
正解:A
質問 # 67
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
- A. Option C
- B. Option A
- C. Option B
- D. Option D
正解:C
質問 # 68
Which one of the following SAS procedures displays the data portion of a SAS data set?
- A. DATASETS
- B. CONTENTS
- C. PRINT
- D. FSLIST
正解:C
質問 # 69
A user-defined format has been created using the FORMAT procedure.
How is it stored?
- A. in a memory resident lookup table
- B. in a SAS data set in the WORK library
- C. in a SAS dataset in a permanent SAS data library
- D. in a SAS catalog
正解:D
質問 # 70
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. A compiler error, triggered by an invalid character for the variable Salary.
- C. An execution error, triggered by an invalid character for the variable Salary.
- D. The 1st of potentially many errors, this one occurring on the 4th observation.
正解:C
質問 # 71
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 is not a variable in the data set GT100.
- B. MPG is not a numeric variable.
- C. LOAD must be defined prior to the SET statement.
- D. LOAD is not variable in the data set AIRPLANES.
正解:D
質問 # 72
The following SAS program is submitted:
What types of variables are DayOfMonth, MonthOfYear, and Year?
- A. DayOfMonth, Year, and MonthOfYear are character.
- B. DayOfMonth, Year, and MonthOfYear are numeric.
- C. DayOfMonth, Year, and MonthOfYear are date values.
- D. DayOfMonth and Year are numeric. MonthOfYear is character.
正解:B
質問 # 73
The following SAS program is submitted:
data work.products;
Product_Number = 5461;
Item = '1001';
Item_Reference = Item'/'Product_Number;
run;
Which one of the following is the value of the variable ITEM_REFERENCE in the output data set?
- A. 1001/ 5461
- B. 1001/5461
- C. The value can not be determined as the program fails to execute due to errors.
- D. . (missing numeric value)
正解:C
質問 # 74
The following SAS program is submitted:
What is the value of the variable Prod in the output data set?
- A. 0
- B. 1
- C. . (missing numeric)
- D. 2
正解:B
質問 # 75
Given the data sets below:
WORK.EMP with variables:
WORK.NEWHIRE with variables:
The following SAS program is submitted:
The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.
How many variables will the data set WORK.ALLEMP contain?
- A. 0
- B. 1
- C. 2
- D. The program fails execution.
正解:B
質問 # 76
Scenario:
This project will use data set cert.input08a and cert.input08b. At
any time, you may save your program
as program08 in cert\programs.
Both data sets contain a common numeric variable named ID.
Write a program that will use a SAS DATA Step to:
* Combine data sets cert.input08a and cert.input08b by
matching values of the ID variable.
* Write only observations that are in both data sets to a
new data set named results.match08.
* Write all other non-matching observations from either
data set to a new data set named results.nomatch08.
* Exclude all variables that begin with
"ex" from results.nomatch08.
How many observations (rows) are inresults.nomatch08?
正解:
解説:
2
Explanation:
proc sort data=cert.input08b out=work.input08b;
by ID;
run:
SAS code that could be used to solve this project:
proc sort data=cert.input08a out=work.input08a;
by ID;
run:
data results.match08 results.nomatch08 (drop=ex: );
merge work.input08a (in=a) work.input08b (in=b);
by ID;
if a and b then output results.match08;
else output results.nomatch08;
run;
proc contents data=results.match08;
run;
proc contents data=results.nomatch08;
run;
The correct answer is: 2
質問 # 77
Which step displays a listing of all the data sets in the WORK library?
- A. proc contents data=WORK._all_;run;
- B. proc contents data=WORK _ALL_;run;
- C. proc contents lib=WORK.all;run;
- D. proc contents lib=WORKrun;
正解:A
質問 # 78
......
Sasinstitute A00-231認定試験は、SASプログラミングを使用して複雑な問題を解決する候補者の能力を評価するために設計されたさまざまなタスクで構成されています。この試験では、データ操作、データ分析、レポート生成など、幅広いトピックをカバーしています。候補者は、効率的かつ効果的なSASコードを作成し、SASプログラムを解釈およびデバッグし、SAS出力を使用してレポートを作成する能力を実証することが期待されています。この試験では、SASデータセットを操作し、SAS変数を作成および変更し、SAS手順を使用してデータを分析する候補者の能力もテストします。この試験に合格することは、データ分析、ビジネスインテリジェンス、またはSASプログラミングに取り組みたい個人にとって貴重な資格です。
有効なA00-231テスト解答とSASInstitute A00-231試験PDF:https://www.goshiken.com/SASInstitute/A00-231-mondaishu.html
SASInstitute A00-231認定リアル2024年最新の模擬試験:https://drive.google.com/open?id=1u6f09YBq02eMND_gkFQfVg7SxvPKNDkf