In order to help you pass the A00-231 SAS 9.4 Base Programming - Performance-Based Exam, PassQuestion provides you the latest SAS Base Programming Specialist A00-231 Practice Test Questions, which have a very close similarity with real exam. They use professional knowledge and experience to provide SAS Base Programming Specialist A00-231 Practice Test Questions for people ready to participate in SAS Institute A00-231 exam. The accuracy rate of SAS Base Programming Specialist A00-231 Practice Test Questions provided by PassQuestion is very high and they can 100% guarantee you pass the SAS Institute A00-231 exam successfully for one time. 

A00-231 Exam Overview - SAS 9.4 Base Programming - Performance-Based Exam

The SAS Base Programming Specialist (A00-231) exam challenges candidates to apply specific knowledge they have acquired through SAS software training and/or job experience. This exam is based on SAS 9.4 M5. Exams are generally scheduled through Pearson VUE but are also held at various locations around the world on a pre-scheduled basis. 

Exam Information

Exam Name: SAS 9.4 Base Programming - Performance-Based Exam
Exam Code: A00-231
Exam Conducted: This exam is administered by SAS and Pearson VUE.
Total Questions: 40-45 multiple-choice and short-answer questions.
Exam Duration: 135 minutes to complete the exam.
Exam Price: $180 USD
Passing score: 725 (score range from 200 to 1,000 points).
Exam Format: This exam is based on SAS 9.4 M5.

Exam Objectives

Access and Create Data Structures: 20-25% 

• Create temporary and permanent SAS data sets. 
• Investigate SAS data libraries using base SAS utility procedures. 
• Access data. 
• Combine SAS data sets. 
• Create and manipulate SAS date values. 
• Control which observations and variables in a SAS data set are processed and output. 

Manage Data: 35-40% 

• Sort observations in a SAS data set. 
• Conditionally execute SAS statements. 
• Use assignment statements in the DATA step. 
• Modify variable attributes using options and statements in the DATA step. 
• Accumulate sub-totals and totals using DATA step statements. 
• Use SAS functions to manipulate character data, numeric data, and SAS date values. 
• Use SAS functions to convert character data to numeric and vice versa. 
• Process data using DO LOOPS
• Restructure SAS data sets with PROC TRANSPOSE. 
• Use macro variables to simplify program maintenance. 

Error Handling: 15-20% 

• Identify and resolve programming logic errors. 
• Recognize and correct syntax errors. 

Generate Reports and Output: 15-20%

• Generate list reports using the PRINT procedure. 
• Generate summary reports and frequency tables using base SAS procedures. 
• Enhance reports system user-defined formats, titles, footnotes and SAS System reporting options. 
• Generate reports using ODS statements. 
• Export data 

View Online SAS 9.4 Base Programming A00-231 Free Questions

Which statement about SAS libraries is true?
A. You refer to a SAS library by a logical name called a libname.
B. A SAS library is a collection of one or more SAS files that are referenced and stored as a unit.
C. A single SAS library must contain files that are stored in different physical locations.
D. At the end of each session, SAS deletes the contents of all SAS libraries.
Answer: B

Assume that Work. Ds1 and Work.Ds2 exist and the following SAS program is submitted:
ods pdf file='results.pdf';
proc print data=work.ds1;
run;
proc freq data=work.ds1;
proc freq data=work.ds2;
run;
ods pdf close;
How many PDF files are created?
A. 1 PDF file with all the output combined
B. 2 PDF files -- one file for each data set used
C. 2 PDF files -- one for the PRINT output and one for the FREQ output
D. 3 PDF files -- one per procedure request
Answer: A

Assume that Sasuser.One does not exist and that the following SAS program is submitted at the beginning of a new SAS session:
data sasuser.one;
x=1;
y=27;
output one;
run; 
A. The data set Sasuser.One is created with 2 variables and 3 observations.
B. The data set Sasuser.One is created with 2 variables and 0 observations.
C. The data set Work.One is created with 2 variables and 1 observation.
D. The data set Sasuser.One is created with 2 variables and 1 observation.
Answer: B

A PROC PRINT report was created with the following title:
Asia Sports Vehicle Summary
After the PROC PRINT report is run, a programmer would next like to produce a PROC FREQ report with the following title:
Asia Sports Vehicle Summary
Distribution by Make
Which statement(s) would produce the new report titles?
A. title "Distribution by Make";
B. title "Asia Sports Vehicle Summary";
title "Distribution by Make";
C. title "Asia Sports Vehicle Summary";
title2 "Distribution by Make";
D. title "Asia Sports Vehicle Summary";
subtitle "Distribution by Make";
Answer: C

The variable Name in the data set Employee has a $CHAR10. format. The variable Name in the data set Sales has a $CHAR15. format.The following SAS program is submitted:
data both;
merge employee sales; 
by name; 
run;
What is the format for the variable Name in the data set Both?
A. no format defined
B. $CHAR
C. $CHAR10
D. $CHAR15
Answer: C