SAS Institute A00-231 SAS 9.4 Base Programming — Performance-based exam Online Training
SAS Institute A00-231 Online Training
The questions for A00-231 were last updated at Dec 25,2024.
- Exam Code: A00-231
- Exam Name: SAS 9.4 Base Programming -- Performance-based exam
- Certification Provider: SAS Institute
- Latest update: Dec 25,2024
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 . options dIm = ‘,’; data family; infile ‘file specification’; input relation $ firstname $; run;
- C . data family; infile ‘file specification’ dIm = ‘,’; input relation $ firstname $; run;
- D . data family; infile ‘file specification’; input relation $ firstname $ / dim = ‘,’; run;
Given the SAS data set ONE:
Given the SAS data set WORK.ONE:
The following SAS program is submitted:
Which report is produced?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
The following SAS program is submitted:
data test;
set sasuser.employees;
if 2 le years_service le 10 then
amount = 1000;
else amount = 0;
amount_per_year = years_service / amount
run;
What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for one year?
- A . 0
- B . 0.001
- C . 1
- D . . (missing numeric value)
The following output is created by the FREQUENCY procedure:
Which TABLES option(s) would be used to eliminate the row and column counts and just see the frequencies and percents?
- A . norowcount nocolcount
- B . freq percent
- C . norow nocol
- D . nocounts
The following program is submitted:
proc sort data=SASUSER.PROJECTS out=PSORT;
by Code descending Date Cost;
run;
Which of the following is true concerning the submitted program?
- A . The descending option applies to the variable Code.
- B . The variable Code is sorted by ascending order.
- C . The PSORT data set is stored in the SASUSER library.
- D . The descending option applies to the Date and Cost variables.
Which statement describes a characteristic of the SAS automatic variable _ERROR_?
- A . The _ERROR_ variable maintains a count of the number of data errors in a DATA step.
- B . The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.
- C . The _ERROR_ variable can be used in expressions in the DATA step.
- D . The _ERROR_ variable contains the number of the observation that caused the data error.
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 . 11
- B . 22
- C . 33
- D . (missing numeric value)
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
The following SAS program is submitted:
data work.retail;
cost = ‘20000’;
total= .10* cost
run;
What is the result?
- A . The value of the variable TOTAL in the output data set is 2000.
No messages are written to the SAS log. - B . The value of the variable TOTAL in the output data set is 2000.
A note that conversion has taken place is written to the SAS log. - C . The value of the variable TOTAL in the output data set is missing.
An error message is written to the SAS log. - D . The variable TOTAL in the output data set has no value.
The program fails to execute due to a syntax error.
A user-defined format has been created using the FORMAT procedure. Where is it stored?
- A . in a SAS catalog
- B . in an external binary file
- C . in a SAS dataset in the WORK library
- D . in a SAS dataset in a permanent SAS data library
Latest A00-231 Dumps Valid Version with 262 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
