[2023年12月14日] 合格率取得する秘訣はA00-231認定試験エンジンPDF [Q50-Q71]

[2023年12月14日] 合格率取得する秘訣はA00-231認定試験エンジンPDF

A00-231試験問題集合格できるには更新された2023年12月テスト問題集

質問 # 50
The contents of the SAS data set PERM.JAN_SALES are listed below:
VARIABLE NAME TYPE
idnum character variable
sales_date numeric date value
A comma delimited raw data file needs to be created from the PERM.JAN_SALES data set. The SALES_DATE values need to be in a MMDDYY10 form.
Which one of the following SAS DATA steps correctly creates this raw data file?

A. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dlm = ','; put idnum sales_date : mmddyy10.; run;
B. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dlm = ','; run;
C. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification' dsd = ','; put idnum sales_date : mmddyy10.; run;
D. libname perm 'SAS-data-library'; data _null_; set perm.jan_sales; file 'file-specification'; put idnum sales_date : mmddyy10. dsd = ','; run;

正解：A

質問 # 51
The Excel workbook QTR1.XLS contains the following three worksheets:
JAN
FEB
MAR
Which statement correctly assigns a library reference to the Excel workbook?

A. libname jan feb mar 'qtr1.xls';
B. libname 'qtr1.xls' sheets=3;
C. libname mydata 'qtr1.xls' WORK.heets=(jan,feb,mar);
D. libname qtrdata 'qtr1.xls';

正解：D

質問 # 52
Which step sorts the observations of a permanent SAS data set by two variables and stores the sorted observations in a temporary SAS data set?

A. proc sort out=EMPLOYEES data=EMPSORT;by Lname and Fname;run;
B. proc sort data=SASUSER.EMPLOYEES out=SASUSER.EMPSORT;by Lname and Fname;run;
C. proc sort data=SASUSER.EMPLOYEES out=EMPSORT;by Lname Fname;run;
D. proc sort out=SASUSER.EMPLOYEES data=WORK.EMPSORT;by Lname Fname;run;

正解：C

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

正解：C

質問 # 54
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. REPORT.
B. WORK
C. HOUSES
D. SASUSER

正解：B

質問 # 55
The following SAS program is submitted:
data work.month;
date = put('13mar2000'd,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?

A. numeric, 10 bytes
B. character, 10 bytes
C. character, 8 bytes
D. numeric, 8 bytes

正解：B

質問 # 56
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. dayofweek(dte)
B. weekday(dte)
C. datdif(dte,'01jan2005'd,'act/act')
D. day(dte)

正解：B

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

質問 # 58
When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100); run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500); run;
How many observations are processed by each procedure?

A. 500 for PROC PRINT5000 for PROC MEANS
B. 401 for PROC PRINT4500 for PROC MEANS
C. 400 for PROC PRINT4500 for PROC MEANS
D. 401 for PROC PRINT4501 for PROC MEANS

正解：D

質問 # 59
The following SAS program is submitted:
data stats;
set revenue;
array weekly{5} mon tue wed thu fri;
total = weekly{i} * .25;
output;
end;
run;
Which one of the following DO statements completes the program and processes the elements of the WEEKLY array?

A. do i = mon tue wed thu fri;
B. do i = 1 to 5;
C. do weekly{i} = 1 to 5;
D. A DO loop cannot be used because the variables referenced do not end in a digit.

正解：B

質問 # 60
Given the following raw data record:
----I----10---I----20---I----30
son Travis,
The following output is desired:
Obs relation firstname
1 son Travis
Which SAS program correctly reads in the raw data?

A. data family ( dIm = ','); infile 'tile specification'; input relation $ firstname $; run;
B. data family; infile 'file specification'; input relation $ firstname $ / dim = ','; run;
C. data family; infile 'file specification' dIm = ','; input relation $ firstname $; run;
D. options dIm = ','; data family; infile 'file specification'; input relation $ firstname $; run;

正解：C

質問 # 61
Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN statement and an Assignment statement.
Which statement regarding this program is true?

A. City's value will be assigned one time, State's value 5 times.
B. The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
C. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.
D. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.

正解：A

質問 # 62
The following SAS program is submittad:
data work.sales;
do year = 1 to 5;
do month=1 to 12;
x+1;
output
end;
end;
run;
How many observations are written the WORK SALES data set?

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

正解：B

質問 # 63
The following SAS program is submitted:
data work.test;
Author = 'Agatha Christie';
First = substr(scan(author,1,' ,'),1,1);
run;
Which one of the following is the length of the variable FIRST in the output data set?

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

正解：A

質問 # 64
The contents of the raw data file SIZE are listed below:
--------10-------20-------30
72 95
The following SAS program is submitted:
data test;
infile 'size';
input @1 height 2. @4 weight 2;
run;
Which one of the following is the value of the variable WEIGHT in the output data set?

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

正解：C

質問 # 65
Which ODS statement option terminates output being written to an HTML rile?

A. QUIT
B. CLOSE
C. END
D. STOP

正解：B

質問 # 66
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?

A. The output displays only a list of the SAS data sets that are contained in the WORK library.
B. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
C. The output displays only the variables in the SAS data sets that are contained in the WORK library.
D. The output displays only the metadata of the SAS data sets that are contained in the WORK library.

正解：B

質問 # 67
Given the contents of the raw data file TYPECOLOR:
----I----10---I----20---I----30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile 'typecolor';
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?

A. No values are stored for the TYPE and COLOR variables.
B. type colordaisygreen
C. type colordaisy ellow
D. type colordaisyyellow" "(missing character value)

正解：C

質問 # 68
The SAS data set BANKS is listed below:
BANKS
name rate
FirstCapital 0.0718
DirectBank 0.0721
VirtualDirect 0.0728
The following SAS program is submitted:
data newbank;
do year = 1 to 3;
set banks;
capital + 5000;
end;
run;
Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

A. 3 observations and 3 variables
B. 0 observations and 0 variables
C. 1 observations and 4 variables
D. 9 observations and 2 variables

正解：C

質問 # 69
A SAS PRINT procedure output of the WORK.LEVELS data set is listed below:
Obs name level
1 Frank 1
2 Joan 2
3 Sui 2
4 Jose 3
5 Burt 4
6 Kelly .
7 Juan 1
The following SAS program is submitted:
data work.expertise;
set work.levels;
if level = . then
expertise = 'Unknown';
else if level = 1 then
expertise = 'Low';
else if level = 2 or 3 then
expertise = 'Medium';
else
expertise = 'High';
run;
Which of the following values does the variable EXPERTISE contain?

A. Low, Medium, High, Unknown, and '' (missing character value)
B. Low, Medium, High, and Unknown only
C. Low, Medium, and High only
D. Low, Medium, and Unknown only

正解：D

質問 # 70
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?