A00-231のPDF問題集で2024年03月23日最近更新された問題 [Q127-Q144]

A00-231のPDF問題集で2024年03月23日最近更新された問題

A00-231試験問題有効なA00-231問題集PDF

SASINSTITUTE A00-231（SAS 9.4ベースプログラミング - パフォーマンスベース）認定試験は、データ管理と分析の分野の専門家にとって貴重な資格です。この試験では、SASプログラミングとデータ管理における候補者のスキルと知識を検証します。これにより、キャリアを前進させ、雇用市場で競争上の優位性を獲得できます。候補者は、トレーニングコースを受講し、学習ガイドと練習試験を使用し、SASソフトウェアでの実践的な経験を積むことにより、試験の準備をすることができます。

SASInstituteのA00-231試験は、SASプログラミングの専門家にとって貴重な資格です。この認定は、候補者がSASプログラミングのタスクを効果的に実行するために必要なスキルと知識を持っていることを雇用主に示し、求職者にとっては競争力のある優位性を提供し、新しいキャリアの機会を開拓することができます。全体的に、SASInstituteのA00-231試験は、個人がSASプログラミングのスキルと知識を検証し、専門家としての地位を確立するための優れた方法です。

SASInstitute A00-231認定試験は、SASプログラミングとデータ分析の分野で非常に高い評価を受けている認定試験です。データ分析やSASプログラミングの分野でキャリアを進める個人にとって欠かせない資格であり、候補者がSAS 9.4を使用して複雑なデータ問題に有益な洞察と解決策を提供できる必要なスキルと知識を持っていることを雇用主に示すことができます。

質問 # 127
The following SAS program is submitted:
data test;
set chemists;
jobcode = 'Chem2'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
The value for the variable JOBCODE is:
JOBCODE
-------------
chem2
What is the value of the variable DESCRIPTION?

A. ' ' (missing character value)
B. Senior Chemist
C. Unknown
D. chem2

正解：C

質問 # 128
The following SAS program is submitted:
data work.passengers;
if OrigPassengers = . then'
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
TotalPassengers = sum (OrigPassengers, TransPassengers) +0;
run;
What is the value of the TOTALPASSENGERS variable in the output data set?

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

正解：C

質問 # 129
The following SAS program is submitted:
data work. new;
length word $7;
amount = 4;
it amount = 4 then word = 'FOUR';
else if amount = 7
then word = 'SEVEN';
else word = 'NONE!!!';
amount = 7;
run;
What are the values of the AMOUNT and WORD variables in SAS dataset work.new?

A. amount word 4 FOUR
B. amount word 4 NONE!!!
C. amount word 7 FOUR
D. amount word 7 SEVEN

正解：C

質問 # 130
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;
-----
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, ^=, |, ||, ~=.
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)

正解：B

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

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

質問 # 132
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. Russia
B. 0
C. 1
D. Italy

正解：B

質問 # 133
The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered byDepartment The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY(keep=Department MonthlyWageRate);
by Department;
if First.Department=1 then Payroll=0;
Payroll+(MonthlyWageRate*12);
if Last.Department=1; run;
Which statement is true? Select one:

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

正解：A

質問 # 134
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:

What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?

A. LocalFee has format of 9. and CountryFee has a format of percent7.2
B. LocalFee has format of 9. and CountryFee has a format of 7.
C. The data step fails execution; there is no format for LocalFee.
D. Both LocalFee and CountryFee have a format of percent7.2

正解：D

質問 # 135
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY
fname age fname salary
Bruce 30 Bruce 25000
Dan 40 Bruce 35000
Dan 25000
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?

A. 0
B. 1
C. 2
D. No variables are output to the data set as the program fails to execute due to errors

正解：C

質問 # 136
The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?

A. the code contains a syntax error and does not execute.
B. the character value "01Jan1960"
C. the date value 01011960
D. the numeric value 0

正解：D

質問 # 137
The following SAS program is submitted:
data work.totalsales (keep = monthsales{12} );
set work.monthlysales (keep = year product sales);
array monthsales {12} ;
do i=1 to 12;
monthsales{i} = sales;
end;
run;
The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a total of 60 observations.
Which one of the following is the result of the above program?

A. The program fails execution due to syntax errors.
B. The program fails execution due to data errors.
C. The program executes with warnings and creates the WORK.TOTALSALES data set.
D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set

正解：A

質問 # 138
The following SAS program is submitted:

What types of variables are DayOfMonth, MonthOfYear, and Year?

A. DayOfMonth, Year, and MonthOfYear are date values.
B. DayOfMonth, Year, and MonthOfYear are character.
C. DayOfMonth and Year are numeric. MonthOfYear is character.
D. DayOfMonth, Year, and MonthOfYear are numeric.

正解：D

質問 # 139
The following SAS program is submitted:
proc sort data = sasuser.houses out = houses;
by style;
run;
proc print data = houses;
run;
Click on the Exhibit button to view the report produced.
style bedrooms baths price
CONDO 2 1.5 80050
3 2.5 79350
4 2.5 127150
2 2.0 110700
RANCH 2 1.0 64000
3 3.0 86650
3 1.0 89100
1 1.0 34550
SPLIT 1 1.0 65850
4 3.0 94450
3 1.5 73650
TWOSTORY 4 3.0 107250
2 1.0 55850
2 1.0 69250
4 2.5 102950
Which of the following SAS statement(s) create(s) the report?

A. id style;by style;var style bedrooms baths price;
B. id style;
C. id style;var style bedrooms baths price;
D. id style;by style;var bedrooms baths price;

正解：D

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

A. SAS will write a NOTE to the SAS log and continue execution.
B. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
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.

正解：B

質問 # 141
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?

A. (space)
B. : (colon)
C. , (comma)
D. ; (semicolon)

正解：A

質問 # 142
The SAS data set Fed.Banks contains a variable Open_Date which has been assigned a permanent label of "Open Date".
Which SAS program temporarily replaces the label "Open Date" with the label "Starting Date" in the output?

A. proc print data=SASUSER.HOUSES label; label Open_Date="Starting Date"; run;
B. proc print data=SASUSER.HOUSES label; label Open_Date "Starting Date"; run;
C. proc print data=SASUSER.HOUSES; label Open_Date="Starting Date"; run;
D. proc print data=SASUSER.HOUSES; Open_Date="Starting Date"; run;

正解：A

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

Which TABLES statement was used to completed the following program that produced the output?
proc freq data=sales;
<_insert_code_>
run;