[Dec 23, 2023] A00-231 Dumps PDF and Test Engine Exam Questions - Pass4SureQuiz
Verified A00-231 exam dumps Q&As with Correct 265 Questions and Answers
The SASInstitute A00-231 exam is conducted online and can be taken from anywhere in the world. A00-231 exam duration is 2 hours and 30 minutes, and candidates will have to solve a set of performance-based questions. A00-231 exam is available in multiple languages, including English, French, German, Japanese, and Spanish, among others.
SASInstitute A00-231 certification exam consists of 50-55 multiple-choice and short-answer questions that must be completed within 2.5 hours. A00-231 exam is performance-based, which means that candidates are required to perform tasks in a simulated SAS environment. A00-231 exam covers topics such as SAS programming fundamentals, data manipulation, data analysis, and reporting. SAS 9.4 Base Programming - Performance-based exam certification exam is available in multiple languages, including English, French, German, and Japanese.
NEW QUESTION # 63
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
Answer: A
NEW QUESTION # 64
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')
Answer: A
NEW QUESTION # 65
The following SAS program is submitted:
data work.test;
array items{3} _temporary_;
run;
What are the names of the variable(s) in the WORKTEST data set?
- A. The program fails to execute because there are no variables listed on the ARRAY statement.
- B. No variables are created because it is a temporary array.
- C. ITEMS1, ITEMS2, ITEMS3
- D. ITEMS
Answer: B
NEW QUESTION # 66
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. both A or C will work.
- B. where Age not between 15 and 16 then Group=1; else Group=2;
- C. if Age not in(15,16) then Group=1; else Group=2;
- D. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
Answer: C
NEW QUESTION # 67
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?
- A. 0
- B. 1
- C. (missing numeric value)
- D. 2
Answer: B
NEW QUESTION # 68
The following SAS program is submitted:
What is the initial value of the variable Total in the following program?
- A. Missing
- B. The value of the first observations Wagerate
- C. Cannot be determined from the information given
- D. 0
Answer: A
NEW QUESTION # 69
The following SAS program is submitted:
The program fails execution due to syntax errors.
What is the cause of the syntax error?
- A. The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
- B. An array cannot be referenced on a KEEP data set option.
- C. The KEEP= data set option should be (KEEP = MONTHSALES).
- D. The variable MONTHSALES does not exist.
Answer: B
NEW QUESTION # 70
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 ascending IDNumber ascending Expenses;
- B. by IDNumber Expenses;
- C. by ascending Expenses IDNumber;
- D. by Expenses IDNumber;
Answer: B
NEW QUESTION # 71
The following SAS program is submitted:
data numrecords;
infile 'file specification';
input@1 patient $15. relative$ 16-26@;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15. clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step execution?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 72
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. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
- B. City's value will be assigned one time, State's value 5 times.
- C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as theLENGTH statement has been omitted.
- D. 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.
Answer: B
NEW QUESTION # 73
The observations in the SAS data set WORK.TEST are ordered by the values of the variable SALARY. The following SAS program is submitted:
proc sort data = work.test out = work.testsorted;
by name;
run;
Which one of the following is the result of the SAS program?
- A. The data set WORK.TEST is stored in descending order by values of the NAME variable.
- B. The data set WORK.TESTSORTED is stored in ascending order by values of the NAME variable.
- C. The data set WORK.TESTSORTED is stored in descending order by values of the NAME variable.
- D. The data set WORK.TEST is stored in ascending order by values of the NAME variable.
Answer: B
NEW QUESTION # 74
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(grandtot,cost);
- B. retain grandtot 0;grandtot = sum(grandtot,cost);
- C. grandtot = sum cost;
- D. grandtot = sum(grandtot,cost);output grandtot
Answer: B
NEW QUESTION # 75
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
Answer: D
NEW QUESTION # 76
This questions will ask you to provide two missing variable names.
The following SAS program is submitted:
data WORK.TOTAL;
set WORK.SALARY;
by Department Gender;
if First. <insert variable 1 here> then Payroll=0
Payroll+Wagerate;
if Last.<insert variable 2 here>;
run;
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. variable 1: Gender variable 2: Gender
- B. variable 1: Department variable 2: Gender
- C. variable 1: Gender variable 2: Department
- D. variable 1: Department variable 2: Department
Answer: A
NEW QUESTION # 77
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. type colordaisy ellow
- B. type colordaisygreen
- C. No values are stored for the TYPE and COLOR variables.
- D. type colordaisyyellow" "(missing character value)
Answer: A
NEW QUESTION # 78
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 dataset in a permanent SAS data library
- C. in a SAS catalog
- D. in a SAS data set in the WORK library
Answer: C
NEW QUESTION # 79
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;var style bedrooms baths price;
- B. id style;by style;var bedrooms baths price;
- C. id style;by style;var style bedrooms baths price;
- D. id style;
Answer: B
NEW QUESTION # 80
Which of the following programs correctly invokes the DATA Step Debugger?
- A. Option B
- B. Option A
- C. Option C
- D. Option D
Answer: C
NEW QUESTION # 81
The following SAS program is submitted:
What will the data set WORK.TEST contain?
- A. Option B
- B. Option A
- C. Option C
- D. Option D
Answer: B
NEW QUESTION # 82
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 prevents SAS from loading a new record when the end of the current record is reached.
- C. 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.
- 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.
Answer: B
NEW QUESTION # 83
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
length EmpId $6;
CharEmpid=EmpId;
run;
If data set WORK.DEPARTMENT has a numeric variable EmpId.
Which statement is true about the output dataset?
- A. The type of the variable CharEmpid is unknown.
- B. The type of the variable CharEmpid is character.
- C. The program fails to execute due to errors.
- D. The type of the variable CharEmpid is numeric.
Answer: C
NEW QUESTION # 84
The following SAS program is submitted:
data temp.x;
set sasuser.y;
run;
What must be submitted prior to this SAS program for the program to execute successfully?
- A. A LIBNAME statement for the libref TEMP only must be submitted.
- B. A LIBNAME statement for the libref SASUSER only must be submitted.
- C. LIBNAME statements for the librefs TEMP and SASUSER must be submitted.
- D. No LIBNAME statement needs to be submitted.
Answer: A
NEW QUESTION # 85
Given the SAS data set WORK.PRODUCTS:
How many observations does the WORK.OUTDOOR data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION # 86
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?
- A. proc print data=MYXLS.NORTH;run;
- B. proc print data=MYXLS.NORTH$;run;
- C. proc print data=MYXLS.'NORTH$'n;run;
- D. proc print data=MYXLS.'NORTH'e;run;
Answer: C
NEW QUESTION # 87
......
SASInstitute A00-231 Test Engine PDF - All Free Dumps: https://www.pass4surequiz.com/A00-231-exam-quiz.html
Get New A00-231 Certification – Valid Exam Dumps Questions: https://drive.google.com/open?id=1f_RHeaPU1mBs-SLSxVJI0gbPbyWcvTLT