[UPDATED 2022] SASInstitute A00-211 Questions Prepare with Free Demo of PDF
NEW 2022 Certification Sample Questions A00-211 Dumps & Practice Exam
What is the duration, language, and format of A00-211 : SAS Certified Base Programmer for SAS 9 Exam
- Format: Multiple choices, multiple answers, short answer questions.
- Passing score: 73.5%
- Language: Czech, simplified Chinese, traditional Chinese, Dutch, English (UK), English (US), French, German, Indonesian, Italian, Japanese, Korean, Polish, Portuguese, Portuguese (Brazil), Russian, Slovak, Spanish, Spanish (Latin America), Thai, Turkish, and Vietnamese
- Length of Examination: 125 minutes
- Number of Questions: 40-45 multiple-choice and short-answer questions.
NEW QUESTION 108
Consider the data step:
Which of the following assignment statements for variable group are functionally equivalent to the original statement used in the above data step?
- A. if Age not in(15,16) then Group=1; else Group=2;
- B. if (Age NE 16) or (Age NE 15) then Group=1; else Group=2;
- C. where Age not between 15 and 16 then Group=1; else Group=2;
- D. both A or C will work.
Answer: A
NEW QUESTION 109
The Excel workbook REGIONS.XLS contains the following four worksheets:
EAST WEST NORTH SOUTH
The following program is submitted: libname MYXLS 'regions.xls';
Which PROC PRINT step correctly displays the NORTH worksheet?
- A. proc print data=MYXLS.'NORTH$'n; run;
- B. proc print data=MYXLS.NORTH; run;
- C. proc print data=MYXLS.NORTH$; run;
- D. proc print data=MYXLS.'NORTH'e;
run;
Answer: A
NEW QUESTION 110
The following SAS program is submitted:
data work.test;
Title = 'A Tale of Two Cities, Charles
J. Dickens';
Word = scan(title,3,' ,');
run;
Which one of the following is the value of the variable WORD in the output data set?
- A. ' ' (missing character value)
- B. Dickens
- C. of
- D. T
Answer: A
NEW QUESTION 111
The following SAS program is submitted: data work.one;
x = 3; y = 2; z = x ** y; run;
Which one of the following is the value of the variable Z in the output data set?
- A. 0
- B. 1
- C. . (missing numeric value)
- D. The program fails to execute due to errors.
Answer: B
NEW QUESTION 112
The SAS data set named WORK.TEST is listed below:
capacity airplanetype staff
150 Large 10
Which one of the following SAS programs created this data set?
- A. data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
else
do;
airplanetype = 'Small';
staff = 5;
end;
run; - B. data work.test;
capacity = 150;
if 100 le capacity le 200 then;
airplanetype = 'Small';
staff = 5;
else;
airplanetype = 'Large';
staff = 10;
run; - C. data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
end;
else
do;
airplanetype = 'Small';
staff = 5;
end;
run; - D. data work.test;
capacity = 150;
if 100 le capacity le 200 then
airplanetype = 'Large' and staff = 10;
else airplanetype = 'Small' and staff = 5;
run;
Answer: C
NEW QUESTION 113
Which one of the following SAS statements renames two variables?
- A. set work.dept1
work.dept2(rename = (jcode = jobcode)
(sal = salary)); - B. set work.dept1 work.dept2(rename = jcode = jobcode sal = salary);
- C. set work.dept1 work.dept2(rename = (jcode jobcode) (sal salary));
- D. set work.dept1
work.dept2(rename = (jcode = jobcode
sal = salary));
Answer: D
NEW QUESTION 114
The value 110700 is stored in a numeric variable named SALARY.
Which FORMAT statement displays the value as $110,700.00 in a report?
- A. format salary dollar8.2;
- B. format salary comma8.2 dollar8.2;
- C. format salary dollar11.2;
- D. format salary comma11.2;
Answer: C
NEW QUESTION 115
What is the purpose or the MISSOVER option on the INFILE statement?
- A. It enables SAS to scan the input data records until the character string that is specified in the
@'character-string' expression is round. - B. It causes the DATA step to stop processing if an INPUT statement reaches the end of the current record without finding values for all variables in the statement.
- C. It enables SAS to continue to read the next input data record if it does not find values in the current input tine for all the variables in the statement.
- D. It prevents SAS from loading a new record when the end of the current record is reached.
Answer: D
NEW QUESTION 116
The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?
- A. PRODUCT and SALES only
- B. An incomplete output data set is created due to syntax errors.
- C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only
- D. PRODUCT, MONTH, NUM_SOLD and COST only
Answer: B
NEW QUESTION 117
Given the following raw data records in TEXTFILE.TXT:
The following output is desired: Which SAS program correctly produces the desired output?
- A. Option A
- B. Option D
- C. Option C
- D. Option B
Answer: C
NEW QUESTION 118
The following SAS program is submitted:
data work.test;
First = 'Ipswich, England';
City_Country = substr(First,1,7)!!', '!!'England';
run;
Which one of the following is the length of the variable CITY_COUNTRY in the output data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 119
Given the SAS data set PERM.STUDENTS:
PERM.STUDENTS NAMEAGE ---------------- Alfred14 Alice13 Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $ age;
<insert statement here>
run;
The following double-spaced file is desired as output
Alfred 14
Alice 13
Barbara 13
Carol 14
Which statement completes the program and creates the desired file?
- A. put _null_;
- B. double;
- C. put
- D. put/;
Answer: C
NEW QUESTION 120
The following SAS program is submitted, creating the SAS data set ONE:
data one;
infile 'file specification';
input num chars$;
run;
ONE
NUMCHAR
123 323 177 The following SAS program is submitted:
proc print data = one;
where char = 23;
run;
What is output?
- A. NUM CHAR 1 23 3 23 1 77
- B. NUM CHAR 1 23 3 23
- C. NUM CHAR 1 77 2
- D. No output is generated.
Answer: D
NEW QUESTION 121
You're attempting to read a raw data file and you see the following messages displayed in the SAS Log:
What does it mean?
- A. A compiler error, triggered by an invalid character for the variable Salary.
- B. An execution error, triggered by an invalid character for the variable Salary.
- C. The 1st of potentially many errors, this one occurring on the 4th observation.
- D. An error on the INPUT statement specification for reading the variable Salary.
Answer: B
Explanation:
Section: Volume B
NEW QUESTION 122
The following SAS program is submitted:
data combine; prefix='505'; middle='6465 '; end='09090'; <insert statement here>; run;
Which statement successfully completes the program so that TOTAL has a value of 5056465
09090?
- A. total = cat('-', prefix, middle, end);
- B. total = prefix !!'-'!! middle ''!!'-'!! end;
- C. total = prefix!!'-'!! left(middle)!!'-'!! end;
- D. total = catx('-', prefix, middle, end);
Answer: D
NEW QUESTION 123
The following SAS program is submitted:
proc contents data=_all_;
run;
Which statement best describes the output from the submitted program?
- A. The output displays a list of the SAS data sets that are contained in the WORK library and displays their metadata.
- B. The output displays only the variables in the SAS data sets that are contained in the WORK library.
- C. The output displays only the metadata of the SAS data sets that are contained in the WORK library.
- D. The output displays only a list of the SAS data sets that are contained in the WORK library.
Answer: A
NEW QUESTION 124
The following program is submitted:
Why does the program fail?
- A. The PAGENO option is invalid in the OPTIONS statement.
- B. The LABEL option is missing from the PROC PRINT statement.
- C. The format name contains a period in the VALUE statement.
- D. The RUN statement is missing after the FORMAT procedure.
Answer: C
NEW QUESTION 125
Given the raw data record DEPT:
----|----10---|----20---|----30
Printing 750
The following SAS program is submitted:
data bonus;
infile 'dept';
inputdept$ 1-11 number 13- 15;
<insert statement here>
run;
Which SAS statement completes the program and results in a value of 'Printing750' for the DEPARTMENT variable?
- A. department = dept II number;
- B. department = trim(dept) number;
- C. department = left(dept) II number;
- D. department=trim(dept)||put(number,3.);
Answer: D
NEW QUESTION 126
The following SAS program is submitted:
proc print data = sasuser.houses; run;
proc means data = sasuser.shoes; run;
Which one of the following OPTIONS statements resets the page number to 1 for the second report?
- A. options pageno = 1;
- B. options reset pageno = 1;
- C. options reset pagenum = 1;
- D. options pagenum = 1;
Answer: A
NEW QUESTION 127
The following SAS program is submitted:
libname sasdata 'SAS-data-library';
data test;
set sasdata.chemists;
if jobcode = 'chem3'
then description = 'Senior Chemist';
else description = 'Unknown';
run;
A value for the variable JOBCODE is listed below:
JOBCODE
CHEM3
Which one of the following values does the variable DESCRIPTION contain?
- A. chem3
- B. Unknown
- C. ' ' (missing character value)
- D. Senior Chemist
Answer: B
NEW QUESTION 128
After a SAS program is submitted, the following is written to the SAS log:
105 data WORK.JANUARY;
106 set WORK.ALLYEAR(keep=Product Month Quantity Cost);
107 if Month='JAN' then output WORK.JANUARY;
108 Sales=Cost * Quantity;
109 drop=Month Quantity Cost;
ERROR 22-322: Syntax error, expecting one of the following: !,
!!, , *, **, +, -,
, <=, <>, =, >, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL,
NOTIN, OR, ^=, |, ||, ~=.
110 run;
What data set option could be attached to WORK.JANUARY to replace the DROP statement that generated the error in the log?
- A. (drop Month, Quantity, Cost)
- B. (drop=Month Quantity Cost)
- C. (drop=Month, Quantity, Cost)
- D. (drop Month Quantity Cost)
Answer: D
NEW QUESTION 129
......
SASInstitute A00-211 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
| Topic 10 |
|
| Topic 11 |
|
Who should take the A00-211 : SAS Certified Base Programmer for SAS 9 Exam
Individuals should pursue the A00-211 Exam if they want to demonstrate their expertise and ability to access and manage data to perform queries and analyses from A00-211 : SAS Certified Base Programmer for SAS 9 Certification
- Data managers
- Programmers
- Or anyone writing & interested in SAS programs
- Analysts
A00-211 Deluxe Study Guide with Online Test Engine: https://www.updatedumps.com/SASInstitute/A00-211-updated-exam-dumps.html