sas A00-211 Exam Questions
Questions for the A00-211 were updated on : Nov 21 ,2025
Page 1 out of 18. Viewing questions 1-15 out of 270
Question 1
The following SAS program is submitted:
data WORK.PRODUCTS;
Prod=1;
do while (Prod LE 7);
Prod + 1;
end;
run;
What is the value of the variable Prod in the output data set?
- A. 7
- B. 8
- C. 6
- D. .(missing numeric)
Answer:
B
Question 2
The following SAS program is submitted:
Data WORK.COMPRESS;
ID = ‘1968 05-10 567’;
NewID = compress (ID, “-“);
run;
What will the value of NewID be in the WORK.COMPRESS data set?
- A. 1968 05-10 567
- B. 19680510567
- C. 196805-10567
- D. 1968 0510 567
Answer:
A
Question 3
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: Gender variable 2: Department
- B. variable 1: Gender variable 2: Gender
- C. variable 1: Department variable 2: Gender
- D. variable 1: Department variable 2: Department
Answer:
B
Question 4
Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable
Month:
The following SAS program is submitted:
proc sort data=WORK.TEMPS;
by Day descending Month;
run;
proc print data=WORK.TEMPS;
run;
Which output is correct?
- D. Option
Answer:
B
Question 5
Given the following data set WORK.TOYS:
The following SAS program s submitted:
data WORK.GROUPS;
set WORK.TOYS;
if Product=”Cards” then Group_Desc=”Indoors”;
else if Product in (“Drum”, “Recorder”) then Group_Desc=“Instruments”;
else if Product=”Ball” then Group_Desc=”Outdoors”;
run;
proc print data=WORK.GROUPS noobs;
run;
Which output is produced?
- D. Option
Answer:
C
Question 6
The Excel workbook REGIONS.XLSX contains the following four worksheets:
EAST
WEST
NORTH
SOUTH
The following program is submitted:
libname MYXLS XLSX ‘c:\ data\ regions.xlsx’;
Which PROC PRINT step correctly displays the NORTH worksheet?
- A. proc print data=MYXLS.‘NORTH’e;run;
- B. proc print data=MYXLS.NORTH.XLSX;run;
- C. proc print data=MYXLS.NORTH;run;
- D. proc print data=MYXLS.‘NORTH$’n;run;
Answer:
D
Question 7
A SAS programmer assigns a library reference to an existing Excel workbook named exceldata.xlsx.
Using a DATA step, the programmer attempts to create a worksheet named outdata in this Excel
workbook. However, the Excel workbook already contains a worksheet named outdata.
What will happen?
- A. A second copy of the workbook named exceldata(2).xlsx. will be created with the new worksheet outdata.
- B. A second worksheet outdata(2) will be added to the existing exceldata.xlsx workbook.
- C. The program will overwrite the outdata worksheet in the exceldata.xlsx workbook.
- D. The program will produce an error message indicating that the exceldata.xlsx workbook already exists.
Answer:
A
Question 8
When SAS encounters a data when reading from a raw data file, which action will occur?
- A. SAS will write an ERROR message to the SAS log and suspend execution.
- B. SAS will write a WARNING message to the SAS log and suspend execution.
- C. SAS will write a NOTE to the SAS log and continue execution.
- D. SAS will print NOTES to the SAS log until the limit that is set by ERRORS = option is reached, then execution will stop.
Answer:
D
Question 9
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable
named Char:
The following SAS program is submitted:
proc print data=WORK.ONE;
where Num=contains (1);
run;
Which output is generated?
- C. Option
- D. No output is generated
Answer:
D
Question 10
Given the SAS data set WORK. PRODUCTS:
The following SAS program is submitted:
data WORK. REVENUE (drop=Sales Returns);
set WORK. PRODUCTS (keep=ProdId Price Sales Returns);
Revenue-Price* (Sales-Returns);
run;
How many variables does the WORK.REVENUE data set contain?
- A. 5
- B. 2
- C. 4
- D. 3
Answer:
A
Question 11
Given the data set WORK.DEPARTMENTS:
The following SAS program is submitted:
Which output will be generated?
- D. Option
Answer:
B
Question 12
Given the raw data file ‘DEPENDENTS.TXT’:
The following SAS program is submitted:
What will be the value of _ERROR_ in the Program Data Vector for each iteration of the DATA step?
- D. Option
Answer:
B
Question 13
After a SAS program is submitted, the following is written to the SAS log:
What issue generated the error in the log?
- A. There should have been commas between the variable names.
- B. The list of variables should have been enclosed in parentheses.
- C. A drop statement and a keep= data set option cannot both be used at the same time.
- D. The syntax of the drop statement does not use an equals sign.
Answer:
C
Reference:
http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000202902
.htm
Question 14
There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:
What will be the value of NewVar when SAS writes the last observation?
- A. 451
- B. 1
- C. 0
- D. . (a missing value)
Answer:
A
Question 15
The following SAS program is submitted:
If the value for the Alumcode is: ALUM2, what is the value of the variable Description?
- B. Unknown
- C. GRAD LEVEL
- D. ‘’ (missing character value)
Answer:
A