[Sep 15, 2022] Get New A00-211 Practice Test Questions Answers
A00-211 Dumps and Exam Test Engine
Topics of A00-211 : SAS Certified Base Programmer for SAS 9 Exam
Candidates should apprehend the examination topics before they begin of preparation. because it'll extremely facilitate them in touch the core. Our A00-211 Dumps will include the following topics:
1. Accessing Data
- Access an Excel workbook.
- Use various components of an INPUT statement to process raw data files including column and line pointer controls, and trailing @ controls.
- Use INFILE statement options to control processing when reading raw data files.
- Use FORMATTED and LIST input to read raw data files.
- Combine SAS data sets.
2. Creating Data Structures
- Control which observations and variables in a SAS data set are processed and output.
- Create and manipulate SAS date values.
- Export data to create standard and comma-delimited raw data files.
- Create temporary and permanent SAS data sets.
3. Managing Data
- Use SAS functions to manipulate character data, numeric data, and SAS date values.
- Process data using DO LOOPS.
- Accumulate sub-totals and totals using DATA step statements.
- Use SAS functions to convert character data to numeric and vice versa.
- Use assignment statements in the DATA step.
- Process data using SAS arrays.
4. Generating Reports
- Enhance reports through the use of user-defined formats, titles, footnotes and SAS System reporting.
- Generate list reports using the PRINT procedure.
- Generate summary reports and frequency tables using base SAS procedures.
- Generate reports using ODS statements.
5. Handling Errors
- Recognize and correct syntax errors.
- Examine and resolve data errors.
- Identify and resolve programming logic errors.
A00-211 : SAS Certified Base Programmer for SAS 9 Certified Professional salary
The average salary of a A00-211 : SAS Certified Base Programmer for SAS 9 Certified Expert in
- England - 46,632 POUND
- India - 8,42,327 INR
- Europe - 45,347 EURO
- United State - 70,247 USD
NEW QUESTION 115
The following SAS program is submitted:
What is produced as output?
- A. A file named test.cvs that can only be opened by SAS.
- B. A text file named test.cvs that can be opened in Excel or in any text editor.
- C. A text file named test.cvs that can only be opened in a text editor.
- D. A file named test.cvs that can only be opened in Excel.
Answer: B
NEW QUESTION 116
Which ODS statement option terminates output being written to an HTML rile?
- A. CLOSE
- B. STOP
- C. QUIT
- D. END
Answer: A
Explanation:
Section: Volume A
NEW QUESTION 117
The SASDATA.BANKS data set has five observations when the following SAS program is submitted:
libname sasdata 'SAS-data-library';
data allobs;
set sasdata.banks;
capital=0;
do year = 2000 to 2020 by 5;
capital + ((capital+2000) * rate);
output;
end;
run;
How many observations will the ALLOBS data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 118
The following SAS program is submitted:
data WORK.DATE_INFO;
X="01Jan1960" D;
run;
What variable X contains what value?
- A. the date value 01011960
- B. the character value "01Jan1960"
- C. the numeric value 0
- D. the code contains a syntax error and does not execute.
Answer: D
NEW QUESTION 119
The following SAS program is submitted:
If the value for the variable Jobcode is: PILOT2, what is the value of the variable Description?
- A. Unknown
- B. Senior Pilot
- C. ' ' (missing character value)
- D. SENIOR PILOT
Answer: A
NEW QUESTION 120
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 NE 16) or (Age NE 15) then Group=1; else Group=2;
- B. where Age not between 15 and 16 then Group=1; else Group=2;
- C. if Age not in(15,16) then Group=1; else Group=2;
- D. both A or C will work.
Answer: C
NEW QUESTION 121
The following SAS program is submitted:
How many observations are written to the WORK.SALES data set?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: D
NEW QUESTION 122
Given the SAS data set WORK.P2000:
And the SAS data set WORK.P2008:
The following output is desired:
Which SAS program correctly combines the data?
- A. Option B
- B. Option C
- C. Option A
- D. Option D
Answer: B
NEW QUESTION 123
The following SAS program is submitted:
What is the value of the variable Prod in the output data set?
- A. 0
- B. . (missing numeric)
- C. 1
- D. 2
Answer: D
NEW QUESTION 124
Given the SAS data set PEPM.STUDENTS:
PERM.STUDENTS NAME AGE
--------- ------ Alfred 14
Alice13
Barbara13
Carol14
The following SAS program is submitted:
libname perm 'SAS data library';
data students;
set perm.students;
file 'file specification';
put name $15. @5 age 2.;
run;
What is written to the output raw data file?
- A. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141
- B. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14
- C. ----I----10---I----20---I----30 Alfred 14 Alice 13 Barbara 13 Carol 14
- D. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4
Answer: D
NEW QUESTION 125
The following SAS program is submitted: What will the data set WORK.TEST contain?
- A. Option B
- B. Option A
- C. Option C
- D. Option D
Answer: B
NEW QUESTION 126
The following SAS program is submitted:
data numrecords;
infile 'file specification';
input@1 patient $15.
relative$ 16-26@;
if relative = 'children' then
input @54 diagnosis $15. @;
else if relative = 'parents' then
input @28 doctor $15.
clinic $ 44-53
@54 diagnosis $15. @;
input age;
run;
How many raw data records are read during each iteration of the DATA step execution?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION 127
The following SAS program is submitted:
data _null_;
set old (keep = prod sales1 sales2);
file 'file-specification';
put sales1 sales2;
run;
Which one of the following default delimiters separates the fields in the raw data file created?
- A. , (comma)
- B. (space)
- C. ; (semicolon)
- D. : (colon)
Answer: B
NEW QUESTION 128
The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department
then payroll = 0;
payroll + wagerate;
if last.department
run;
The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.
What is the result?
- A. The WORKTDTAL data set contains 100 observations.
- B. The WORKTOTAL data set contains 500 observations.
- C. The program fails to execute due to errors.
- D. The WORK.TOTAL data set contains 5 observations.
Answer: D
NEW QUESTION 129
Which one of the following is true of the SUM statement in a SAS DATA step program?
- A. It is only valid in conjunction with a SUM function.
- B. It adds the value of an expression to an accumulator variable and ignores missing values.
- C. It is not valid with the SET, MERGE and UPDATE statements.
- D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.
Answer: B
NEW QUESTION 130
The following SAS program is submitted:
libname temp 'SAS-data-library';
data work.new;
set temp.jobs;
format newdate mmddyy10.;
qdate = qtr(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new;
run;
The variable NEWDATE contains the SAS date value for April 15, 2000.
What output is produced if April 15, 2000 falls on a Saturday?
- A. Obs newdate qdate ddate
1 04/15/2000 2 6 - B. Obs newdate qdate ddate
1 APR152000 2 7 - C. Obs newdate qdate ddate
1 04/15/2000 2 7 - D. Obs newdate qdate ddate
1 APR152000 2 6
Answer: C
Explanation:
Section: Volume B
NEW QUESTION 131
The SAS data set PETS is sorted by the variables TYPE and BREED.
The following SAS program is submitted:
proc print data = pets;
var type breed;
sum number;
run;
What is the result?
- A. The SUM statement produces only a grand total of NUMBER.
- B. Nothing is produced by the SUM statement; the program fails to execute.
- C. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
- D. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
Answer: A
NEW QUESTION 132
By default, which variables and data values are used to calculate statistics in the MEANS procedure?
- A. all missing and non-missing numeric variable values and numbers stored as character variables.
- B. all missing and non-missing numeric variable values
- C. all non-missing numeric variable values
- D. all non-missing numeric variable values and numbers stored as character variables
Answer: C
Explanation:
Section: Volume B
NEW QUESTION 133
The following SAS program is submitted and reads 100 records from a raw data file:
data work.total;
infile 'file-specification' end = eof;
input name $ salary;
totsal + salary;
run;
Which one of the following IF statements writes the last observation to the output data set?
- A. if end = 0;
- B. if end = 1;
- C. if eof = 0;
- D. if eof = 1;
Answer: D
NEW QUESTION 134
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. freq percent
- B. nocounts
- C. norow nocol
- D. norowcount nocolcount
Answer: C
NEW QUESTION 135
Which one of the following statements is true regarding the name of a SAS array?
- A. It can be the same as the name of a variable in the data set.
- B. It is saved with the data set.
- C. It exists only for the duration of the DATA step.
- D. It can be used in procedures.
Answer: C
NEW QUESTION 136
A raw data file is listed below:
--------10-------20-------30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37
The following SAS program is submitted using the raw data file as input:
data work.homework;
infile 'file-specification';
input name $ age height;
if age LE 10;
run;
How many observations will the WORK.HOMEWORK data set contain?
- A. 0
- B. 1
- C. 2
- D. No data set is created as the program fails to execute due to errors.
Answer: C
NEW QUESTION 137
......
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
- Analysts
- Data managers
- Or anyone writing & interested in SAS programs
- Programmers
2022 New Pass4guide A00-211 PDF Recently Updated Questions: https://www.pass4guide.com/A00-211-exam-guide-torrent.html