[2023] Pass A00-231 Exam - Real Questions and Answers
A00-231 Exam Questions Get Updated [2023] with Correct Answers
Know what topics are covered in the SAS Institute A00-231 Exam
Error Handling: 15-20%
Access and Create Data Structures: 20-25%
Manage Data: 35-40%
Generate Reports and Output: 15-20%
What is the salary of an SAS Base Programming Specialist?
The Average salary of different countries of SAS Base Programming Specialist
- United States - $13000 USD
- UK - 9801 Pounds
- India - 983845INR
NEW QUESTION 32
Which one of the following SAS procedures displays the data portion of a SAS data set?
- A. CONTENTS
- B. PRINT
- C. DATASETS
- D. FSLIST
Answer: B
NEW QUESTION 33
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: A
NEW QUESTION 34
The contents of the raw data file EMPLOYEE are listed below:
--------10-------20-------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 = 'Sue' then input age 7-8; else input idnum 10-11;
run;
Which one of the following values does the variable AGE contain when the name of the employee is "Sue"?
- A. 0
- B. 1
- C. . (missing numeric value)
- D. 2
Answer: D
NEW QUESTION 35
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
- A. if end = 0;
- B. if end = 1;
- C. if eof = 1;
- D. if eof = 0;
Answer: C
NEW QUESTION 36
The following SAS program is submitted:
data WORK.OUTDS;
do until(Prod GT 6);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?
- A. 0
- B. Undetermined, infinite loop.
- C. (missing)
- D. 1
Answer: D
NEW QUESTION 37
The following SAS program is submitted:
What new variables are created?
- A. Diff1, Diff2 and Diff3
- B. Janpt, Febpt, and Marpt
- C. Difcount1, Difcount2 and Difcount3
- D. Patients1, Patients2 and Patients3
Answer: C
NEW QUESTION 38
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
Answer: B
NEW QUESTION 39
Given the data sets below:
WORK.EMP with variables:
WORK.NEWHIRE with variables:
The following SAS program is submitted:
The SAS data set WORK.EMP has 50 observations, and the data set WORK.NEWHIRE has 4 observations.
How many variables will the data set WORK.ALLEMP contain?
- A. 0
- B. The program fails execution.
- C. 1
- D. 2
Answer: C
NEW QUESTION 40
The following SAS program is submitted:
Which statement is true about the output data set?
- A. The program fails to execute due to errors.
- B. The type of the variable CharEmpid is numeric.
- C. The type of the variable CharEmpid is unknown.
- D. The type of the variable CharEmpid is character.
Answer: A
NEW QUESTION 41
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 42
The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
What is the value of the CITY variable?
- A. ''(missing character value)
- B. Copenhagen
- C. Other
- D. Copenh
Answer: C
NEW QUESTION 43
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 bedrooms baths price;
- B. id style;by style;var style bedrooms baths price;
- C. id style;var style bedrooms baths price;
- D. id style;
Answer: A
NEW QUESTION 44
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 7 SEVEN
- B. amount word 7 FOUR
- C. amount word 4 FOUR
- D. amount word 4 NONE!!!
Answer: B
NEW QUESTION 45
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS
NAME AGE
Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm. Students;
file 'file specification';
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
- A. ----I----10---I----20---I---- 30 Alfred 14 Alice 13 Barbara 13 Carol 14
- B. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14
- C. ---- I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
- D. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
Answer: C
NEW QUESTION 46
The following SAS program is submitted:
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. Department
- B. Department Gender
- C. Gender Department
- D. Gender
Answer: D
NEW QUESTION 47
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 WORKTOTAL data set contains 500 observations.
- B. The WORKTDTAL data set contains 100 observations.
- C. The WORK.TOTAL data set contains 5 observations.
- D. The program fails to execute due to errors.
Answer: C
NEW QUESTION 48
By default, which variables and data values are used to calculate statistics in the MEANS procedure?
- A. all non-missing numeric variable values and numbers stored as character variables
- B. all missing and non-missing numeric variable values and numbers stored as character variables.
- C. all missing and non-missing numeric variable values
- D. all non-missing numeric variable values
Answer: D
NEW QUESTION 49
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)
Answer: A
NEW QUESTION 50
......
Practice A00-231 Questions With Certification guide Q&A from Training Expert TopExamCollection: https://gocertify.topexamcollection.com/A00-231-vce-collection.html
