You are on page 1of 10

SAS Base Certification Questions - A00-211

A00-211 PDF
____________________________________________________________________________

What is SAS Base Certification?


SAS Base certification questions and exam summary helps you to get focused on exam. This
guide also helps you to be on A00-211 exam track to get certified with good score in final exam.

A00-211 - SAS Base Certification Summary


Exam Name

Certified Base Programmer

Exam Code

A00-211

Exam Duration

110 minutes

Exam Questions

60 to 65 multiple-choice and short-answer questions

Passing Score

70%

Exam Price

$180 (USD)

Training

Not mandatory

Books

SAS Certification Prep Guide: Base Programming for SAS 9,


Third Edition

Exam Registration

Pearson VUE

Sample Questions

SAS Base Programmer Certification Sample Question

Practice Exam

SAS Base Programmer Certification Practice Exam

The ideal certification for those relatively new to SAS programming or new to SAS
certification.
Successful candidates should have experience in programming and data
management using SAS 9 and should be able to
import and export raw data files
manipulate and transform data
combine SAS data sets
create basic detail and summary reports using SAS procedures
identify and correct data, syntax and programming logic errors.

___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________

A00-211 SAS Base Certification Questions:


A00-211 Base SAS Sample questions are provided for each exam to illustrate the
various question types that may appear. For some credentials, a practice exam is
also available.
Question 1
The following program is submitted.
data WORK.TEST;
input Name $ Age;
datalines;
John +35
;
run;
Which values are stored in the output data set?
1. Name
Age
--------------------John

35

2. Name

Age

--------------------John

(missing value)

3. Name

Age

--------------------(missing value)

(missing value)

4. The DATA step fails execution due to data errors.

correct_answer = "A"
Question 2
Given the SAS data set WORK.ONE:
Id Char1
--- ----182 M
190 N
250 O
720 P
and the SAS data set WORK.TWO:
___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
Id Char2
--- ----182 Q
623 R
720 S
The following program is submitted:
data WORK.BOTH;
merge WORK.ONE WORK.TWO;
by Id;
run;
What is the first observation in the SAS data set WORK.BOTH?
1. Id Char1 Char2
--- ----- ----182 M
2. Id Char1 Char2

--- ----- ----182

3. Id Char1 Char2

--- ----- ----182 M

4. Id Char1 Char2

--- ----- ----720 P

correct_answer = "C"
Question 3
Given the text file COLORS.TXT:
----+----1----+----2----+---RED

ORANGE YELLOW GREEN

BLUE

INDIGO PURPLE VIOLET

CYAN

WHITE

FUCSIA BLACK

___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
GRAY BROWN PINK MAGENTA
The following SAS program is submitted:
data WORK.COLORS;
infile 'COLORS.TXT';
input @1 Var1 $ @8 Var2 $ @;
input @1 Var3 $ @8 Var4 $ @;
run;
What will the data set WORK.COLORS contain?
1. Var1
Var2
Var3 Var4
------

------

------ ------

RED

ORANGE

RED

ORANGE

BLUE

INDIGO

BLUE

INDIGO

CYAN

WHITE

CYAN

WHITE

GRAY

BROWN

2. Var1

-----RED
CYAN
3. Var1

------

Var2
------

GRAY

Var3

BROWN

Var4

------ ------

ORANGE

BLUE

INDIGO

WHITE

GRAY

BROWN

Var2
------

Var3

Var4

------ ------

RED

ORANGE

YELLOW GREEN

BLUE

INDIGO

PURPLE VIOLET

4. Var1

------

Var2
------

Var3

Var4

------ ------

RED

ORANGE

YELLOW GREEN

BLUE

INDIGO

PURPLE VIOLET

CYAN

WHITE

FUCSIA BLACK

GRAY

BROWN

PINK

MAGENTA

correct_answer = "A"
Question 4
Given the SAS data set WORK.INPUT:
___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
Var1
Var2
------

-------

one

two

three

four

five

The following SAS program is submitted:


data WORK.ONE WORK.TWO;
set WORK.INPUT;
if Var1='A' then output WORK.ONE;
output;
run;
How many observations will be in data set WORK.ONE?
Enter your numeric answer in the space below.

correct_answer = "8"
Question 5
The following SAS program is submitted:
data WORK.LOOP;
X = 0;
do Index = 1 to 5 by 2;
X = Index;
end;
run;
Upon completion of execution, what are the values of the variables X and
Index in the SAS data set named WORK.LOOP?
1. X = 3, Index = 5
2. X = 5, Index = 5
3. X = 5, Index = 6
4. X = 5, Index = 7

correct_answer = "D"
___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
Question 6
The following SAS program is submitted:
proc format;
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
Which one of the following PRINT procedure steps correctly applies the
format?
1. proc print data = SASUSER.CLASS;
var test;
format test score;
run;
2. proc print data = SASUSER.CLASS;

var test;
format test score.;
run;
3. proc print data = SASUSER.CLASS format = score;

var test;
run;
4. proc print data = SASUSER.CLASS format = score.;

var test;
run;
correct_answer = "B"
Question 7
This item will ask you to provide a line of missing code;
The SAS data set WORK.INPUT contains 10 observations, and includes the
numeric variable Cost.
The following SAS program is submitted to accumulate the total value of
Cost for the 10 observations:
___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
data WORK.TOTAL;
set WORK.INPUT;
<insert code here>
Total=Total+Cost;
run;
Which statement correctly completes the program?
1. keep Total;
2. retain Total 0;
3. Total = 0;
4. If _N_= 1 then Total = 0;

correct_answer = "B"
Question 8
This question will ask you to provide a line of missing code.
Given the following data set WORK.SALES:
SalesID SalesJan FebSales MarchAmt
------- -------- -------- -------W6790

50

400

350

W7693

25

100

125

W1387

300

250

The following SAS program is submitted:


data WORK.QTR1;
set WORK.SALES;
array month{3} SalesJan FebSales MarchAmt;
<insert code here>
run;
Which statement should be inserted to produce the following output?
SalesID SalesJan FebSales MarchAmt Qtr1
------- -------- -------- -------- ---W6790

50

400

350

800

W7693

25

100

125

250

W1387

300

250

550

1. Qtr1 = sum(of month{_ALL_});

___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
2. Qtr1 = month{1} + month{2} + month{3};
3. Qtr1 = sum(of month{*});
4. Qtr1 = sum(of month{3});

correct_answer = "C"
Question 9
Given the following SAS error log
44 data WORK.OUTPUT;
45

set SASHELP.CLASS;

46

BMI=(Weight*703)/Height**2;

47

where bmi ge 20;

ERROR: Variable bmi is not on file SASHELP.CLASS.


48

run;

What change to the program will correct the error?


1. Replace the WHERE statement with an IF statement
2. Change the ** in the BMI formula to a single *
3. Change bmi to BMI in the WHERE statement
4. Add a (Keep=BMI) option to the SET statement

correct_answer = "A"
Question 10
The following SAS program is submitted:
data WORK.TEMP;
Char1='0123456789';
Char2=substr(Char1,3,4);
run;
What is the value of Char2?
1. 23
2. 34
3. 345
4. 2345

correct_answer = "D"
How to Register for SAS Base Certification Exam?
___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________

SAS Base Certification A00-211 Exam Syllabus:


Objective
Accessing

Details (get more detail on SAS Base Certification Questions)


- Use FORMATTED and LIST input to read raw data files.

Data
- Use INFILE statement options to control processing when reading raw
data files.
- Use various components of an INPUT statement to process raw data
files including column and line pointer controls, and trailing @ controls.
- Combine SAS data sets.
- Access an Excel workbook.
Creating
Data
Structures

- Create temporary and permanent SAS data sets.


- Create and manipulate SAS date values.
- Export data to create standard and comma-delimited raw data files.
- Control which observations and variables in a SAS data set are
processed and output.

Managing
Data

- Investigate SAS data libraries using base SAS utility procedures.


- 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.

___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

SAS Base Certification Questions - A00-211


A00-211 PDF
____________________________________________________________________________
- Process data using DO LOOPS.
- Process data using SAS arrays.
- Validate and clean data.
Generating
Reports

- Generate list reports using the PRINT procedure.


- Generate summary reports and frequency tables using base SAS
procedures.
- Enhance reports through the use of user-defined formats, titles,
footnotes and SAS System reporting.
- Generate reports using ODS statements.

Handling
Errors

- Identify and resolve programming logic errors.


- Recognize and correct syntax errors.
- Examine and resolve data errors.

The official guide from the SAS Certification Program that covers all of the
objectives tested in the exam. Topics include importing and exporting raw data
files, creating and modifying SAS data sets, and identifying and correcting data
syntax and programming logic errors.

___________________________________________________________________________
Base SAS Certification Questions - A00-211
A00-211 Questions

You might also like