[May 16, 2024] New Updated A00-231 Exam Questions 2024
Updated Free SASInstitute A00-231 Test Engine Questions with 298 Q&As
NEW QUESTION # 64
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: Department variable 2: Gender
- B. variable 1: Department variable 2: Department
- C. variable 1: Gender variable 2: Department
- D. variable 1: Gender variable 2: Gender
Answer: D
NEW QUESTION # 65
Given the SAS data set WORK.P2000:
And the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION # 66
Given the SAS data set WORK.ONE:
And the SAS data set WORK.TWO:
The following program is submitted:
What is the first observation in the SAS data set WORK.BOTH?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION # 67
The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?
- A. . (missing numeric value)
- B. '2000'
- C. '' (missing character value)
- D. 0
Answer: D
NEW QUESTION # 68
The following SAS program is submitted:
Which statement is true about the output data set?
- A. The label of the variable Jobcode is Job Desc (only the first 8 characters).
- B. The label of the variable Jobcode is Job Description.
- C. The label of the variable Jobcode is Job (only the first word).
- D. Labels can only be defined in PROC steps. The program fails to execute due to errors and the data set is not created.
Answer: B
NEW QUESTION # 69
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION # 70
Given the raw data file EMPLOYEE.TXT:
The following SAS program is submitted:
What value does the variable idnum contain when the name of the employee is "Ruth"?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 71
Given the following raw data records in DATAFILE.TXT:
Which output is correct based on the submitted program?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION # 72
Read the table
The following SAS program is submitted:
proc freq data = sales;
<insert TABLES statement here>
run;
The following output is created by the FREQUENCY procedure:
Which TABLES statement(s) completed the program and produced the output?
- A. tables region * product;
- B. tables region product;
- C. tables product; tables region;
- D. tables product * region;
Answer: A
NEW QUESTION # 73
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 fails execution because the same SAS data set is referenced for both read and write operations.
- B. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
- C. The program executes successfully and a temporary SAS data set is created.
- D. The program executes successfully and a permanent SAS data set is created.
Answer: D
NEW QUESTION # 74
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. a missing value due to syntax errors
- B. the step will not compile because of the character argument in the mdy function.
- C. the character value "01011960"
- D. the numeric value 0
Answer: D
NEW QUESTION # 75
The following SAS program is submitted:
What new variables are created?
- A. Difcount1, Difcount2 and Difcount3
- B. Diff1, Diff2 and Diff3
- C. Janpt, Febpt, and Marpt
- D. Patients1, Patients2 and Patients3
Answer: A
NEW QUESTION # 76
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. ITEMS
- B. No variables are created because it is a temporary array.
- C. ITEMS1, ITEMS2, ITEMS3
- D. The program fails to execute because there are no variables listed on the ARRAY statement.
Answer: B
NEW QUESTION # 77
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. if (Age NE 16) or (Age NE 15) 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. where Age not between 15 and 16 then Group=1;
Answer: A
NEW QUESTION # 78
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 1Wang 2Wang 3Gerard 3Amy 1Amy 2
- B. Wang 3Gerard 3Wang 2Amy 2Wang 1Amy 1
- C. Wang 3Wang 2Wang 1Gerard 3Amy 2Amy 1
- D. Wang 3Wang 1Wang 2Gerard 3Amy 2Amy 1
Answer: A
NEW QUESTION # 79
Given the SAS data set WORK.PRODUCTS:
How many variables does the WORK.REVENUE data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION # 80
......
SASInstitute A00-231 (SAS 9.4 Base Programming - Performance-based) Certification Exam is a professional certification for individuals who wish to prove their proficiency in SAS programming language. A00-231 exam is designed to assess the knowledge and skills needed to write SAS programs to access, explore, transform, and analyze data. A00-231 exam is performance-based, which means that candidates must complete a series of tasks using SAS software within a specified time frame.
Try 100% Updated A00-231 Exam Questions [2024]: https://www.test4cram.com/A00-231_real-exam-dumps.html
The Best SAS Institute Systems A00-231 Professional Exam Questions: https://drive.google.com/open?id=1d-b8xbnz1-DgZ97OjNBGs9KU3dAxjO0Y