[2023年07月14日] A00-231テストエンジンお試しセット、A00-231問題集PDF
最新のSASInstitute A00-231のPDFと問題集で（2023）無料試験問題解答
質問 # 14
The following SAS program is submitted:
data WORK.DATE_INFO;
Day="01" ;
Yr=1960 ;
X=mdy(Day,01,Yr) ;
run;
What is the value of the variable X?
- A. the character value "01011960"
- B. the numeric value 0
- C. the step will not compile because of the character argument in the mdy function.
- D. a missing value due to syntax errors
正解：B
質問 # 15
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
The data set WORK.TWO is created, where Day would be 1 for Sunday, 2 for Monday, 3 for Tuesday, ... :
Which expression successfully completed the program and creates the variable DAY?
- A. getday(BeginDate,today())
- B. weekday(BeginDate)
- C. day(BeginDate)
- D. dayofweek(BeginDate)
正解：B
質問 # 16
The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet;
run;
Which one of the following is needed to display the standard deviation with only two decimal places?
- A. Add the statement FORMAT STD 7.2; in the MEANS procedure step.
- B. Add the option MAXDEC = 2 to the MEANS procedure statement.
- C. Add the option FORMAT = 7.2 option to the MEANS procedure statement.
- D. Add the statement MAXDEC = 7.2; in the MEANS procedure step.
正解：B
質問 # 17
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 numeric value of 14692, which represents the SAS date value for March 23, 2000
- C. a character string with the value '03/23/2000'
- D. a numeric value of 3232000, which represents the SAS date value for March 23, 2000
正解：B
質問 # 18
The contents of the raw data file TEAM are listed below:
--------10-------20-------30
Janice 10
Henri 11
Michael 11
Susan 12
The following SAS program is submitted:
data group;
infile 'team';
input name $15. age 2.;
file 'file-specification';
put name $15. +5 age 2.;
run;
Which one of the following describes the output created?
- A. No output is generated as the program fails to execute due to errors.
- B. a SAS data set named GROUP and a raw data file
- C. a SAS data set named GROUP only
- D. a raw data file only
正解：B
質問 # 19
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 catalog
- D. in a SAS dataset in a permanent SAS data library
正解：C
質問 # 20
What is the purpose or the MISSOVER option on the INFILE statement?
- A. It enables SAS to scan the input data records until the character string that is specified in the @'character-string' expression is round.
- B. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.
- C. It prevents SAS from loading a new record when the end of the current record is reached.
- D. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
正解：C
質問 # 21
Given the data set WORK.EMPDATA:
Which one of the following where statements would display observations with job titles containing the word 'Manager'?
- A. where Job_Title like '%Manager%';
- B. where upcase(scan(Job_Title,-1,''))='MANAGER';
- C. where substr(Job_Title,(length(Job_Title)-6))='Manager';
- D. where Job_Title='% Manager ';
正解：A
質問 # 22
The following SAS program is submitted:
libname company 'SAS-data-library';
proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?
- A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber
- B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
- C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.
- D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
正解：D
質問 # 23
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 {*});
- C. Qtr1 = sum(of month{_ALL_});
- D. Qtr1 = sum(of month {3});
正解：B
質問 # 24
Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
2
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE; else if producttype = 'NETWORK' then output INTER; else if producttype = 'SOFTWARE' then output SOFT; run; How many observations does the HWARE data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
正解：D
質問 # 25
The following SAS program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Product Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
- A. The descending option applies only to the Code variable.
- B. The descending option applies to the Date and Cost variables.
- C. The descending option applies to the Product and Code variables.
- D. The descending option applies only to the Date variable.
正解：B
質問 # 26
Given the SAS data set WORK.EMP_NAME:
Given the SAS data set WORK.EMP_DEPT:
The following program is submitted:
How many observations are in data set WORK.ALL after submitting the program?
- A. 0
- B. 1
- C. 2
- D. 3
正解：D
質問 # 27
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
- A. An incomplete output data set is created due to syntax errors.
- B. PRODUCT, MONTH, NUM_SOLD and COST only
- C. PRODUCT and SALES only
- D. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
正解：A
質問 # 28
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 program fails to execute due to errors.
- B. The WORKTDTAL data set contains 100 observations.
- C. The WORKTOTAL data set contains 500 observations.
- D. The WORK.TOTAL data set contains 5 observations.
正解：D
質問 # 29
The SAS data set WORK.AWARDS is listed below:
fname points
Amy 2
Amy 1
Gerard 3
Wang 3
Wang 1
Wang 2
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
Which one of the following represents how the observations are sorted?
- A. Wang 3Gerard 3Wang 2Amy 2Wang 1Amy 1
- B. Wang 3Wang 1Wang 2Gerard 3Amy 2Amy 1
- C. Wang 1Wang 2Wang 3Gerard 3Amy 1Amy 2
- D. Wang 3Wang 2Wang 1Gerard 3Amy 2Amy 1
正解：C
質問 # 30
The following SAS program is submitted:
libname temp 'SAS data library';
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
- A. The program executes successfully and a permanent SAS data set is created.
- B. The program executes successfully and a temporary SAS data set is created.
- C. The program fails execution because the same SAS data set is referenced for both read and write operations.
- D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
正解：A
質問 # 31
Given the following IF/THEN statement:
If Age NE 16 and Age NE 15 then Group-1;
Which assignment statement for variable Group is functionally equivalent to the original statement used in the above data step?
- A. where Age not between (15 and 16) then Group=1;
- B. if Age not in(15,16) then Group=1;
- C. where Age not between 15 and 16 then Group=1;
- D. if (Age NE 16) or (Age NE 15) then Group=1;
正解：D
質問 # 32
A user-defined format has been created using the FORMAT procedure. Where is it stored?
- A. in a SAS dataset in the WORK library
- B. in a SAS catalog
- C. in a SAS dataset in a permanent SAS data library
- D. in an external binary file
正解：B
質問 # 33
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;
正解：A
質問 # 34
Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- A. if Age not in(15,16) then Group=1; else Group=2;
- B. both A or C will work.
- C. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
- D. where Age not between 15 and 16 then Group=1; else Group=2;
正解：A
質問 # 35
......
SASInstitute A00-231認定試験は、SAS 9.4 Base Programmingでキャリアを進めたい個人にとって必須の資格です。これは、候補者の重要なプログラミングタスクを実行し、SASプログラミングコンセプトを実世界のシナリオに適用する能力を測定するパフォーマンスベースの試験です。A00-231認定は、データ分析および管理業界の雇用主によってグローバルに認められ、高く評価されており、個人が同僚との差別化を図り、多数のキャリア機会を開くための優れた方法です。
あなたを合格させるSAS Institute Systems A00-231試験問題集で2023年07月14日には265問あります：https://www.jpntest.com/shiken/A00-231-mondaishu