Free SASInstitute (A00-211) Certification Sample Questions with Online Practice Test
A00-211 Certification Study Guide Pass A00-211 Fast
How to book A00-211 : SAS Certified Base Programmer for SAS 9 Exams
The registration for the A00-211 : SAS Certified Base Programmer for SAS 9 Exam follows the steps given below:
- Step 1: Visit to website Pearson VUE
- Step 2: Navigate To Certifications.
- Step 3: Search for the exam name A00-211 : SAS Certified Base Programmer for SAS 9
- Step 4: Book the exam.
Introduction to A00-211 : SAS Certified Base Programmer for SAS 9 Exam
According to SAS, SAS® Certified Advanced Programmer for SAS®9 this credentials signifies the upper echelon of SAS programmers who demonstrate a high level of proficiency in SAS® programming expertise.
A00-211 : SAS Certified Base Programmer for SAS 9 Exam is a certification exam that is conducted by Google to validates candidate knowledge and skills of working as a advanced programmer in the Company.
A00-211 : SAS Certified Base Programmer for SAS 9 exam covers the basic and advanced concepts of advanced DATA step programming statements and efficiency techniques to solve complex problems,writing and interpreting SAS SQL code,creating and using the SAS MACRO facility.
After passing this exam, candidates get a certificate from SAS that helps them to demonstrate their proficiency in A00-211 : SAS Certified Base Programmer for SAS 9 to their clients and employers.
NEW QUESTION 85
Given the SAS data set PRICES:
PRICES
prodid price
K12S5.10producttype
NETWORKsales
15returns
B132S 2.34HARDWARE30010
R18KY21.29SOFTWARE255
3KL8BY 6.37HARDWARE12515
DY65DW 5.60HARDWARE455
DGTY23 4.55HARDWARE672
The following SAS program is submitted:
data hware inter soft;
set prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;
How many observations does the HWARE data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 86
Read the table:
Given the SAS data set SASUSER.HOUSES:
Obs style bedrooms baths price sqteet street
1 CONDO 2 1.5 80050 1200 MAIN
2 CONDO 3 2.5 79350 1300 ELM
3 CONDO 4 2.5 127150 1400 OAK
4 CONDO 2 2.0 110700 1100 FIFTH
5 TWOSTORY 4 3.0 107250 2100 SECOND
6 TWOSTORY 2 1.0 55650 1600 WEST
7 TWOSTORY 2 1.0 69250 1450 NORTH
6 TWOSTORY 4 2.5 102950 2000 SOUTH
The following SAS program is submitted:
proc report data = sasuser.houses nowd headline;
column style price;
where price It 100000;
<insert DEFINE statement here>
define price / mean width = 9 format = dollar12.;
title;
run;
The following output is desired:
style price
------- ------
CONDO $79,700
TWOSTORY $62550
Which DEFINE statement completes the program and produces the desired output?
- A. define style / group width = 9;
- B. define style / display width = 9;
- C. define style / orderwidth = 9;
- D. define style / width = 9,
Answer: A
NEW QUESTION 87
The SAS data set WORK.ONE contains a numeric variable named Num and a character variable named
Char:
The following SAS program is submitted:
What is output?
- A. Option D
- B. Option B
- C. Option C
- D. Option A
Answer: A
NEW QUESTION 88
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?
- A. No output is generated
- B.
- C.
- D.
Answer: A
Explanation:
Section: Volume B
NEW QUESTION 89
The following SAS program is submitted:
What types of variables are DayOfMonth, MonthOfYear, and Year?
- A. DayOfMonth, Year, and MonthOfYear are date values.
- B. DayOfMonth, Year, and MonthOfYear are character.
- C. DayOfMonth and Year are numeric. MonthOfYear is character.
- D. DayOfMonth, Year, and MonthOfYear are numeric.
Answer: D
NEW QUESTION 90
The contents of two SAS data sets named EMPLOYEE and SALARY are listed below:
EMPLOYEE SALARY name age name salary Bruce 30 Bruce 40000 Dan 35 Bruce 35000 Dan 37000
Dan .
The following SAS program is submitted:
data work.empsalary;
merge work.employee (in = inemp)
work.salary (in = insal);
by name;
if inemp and insal;
run;
How many observations will the data set WORK.EMPSALARY contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
NEW QUESTION 91
The SAS data set EMPLOYEE_INFO is listed below:
IDNumber Expenses 2542 100.00 3612 133.15 2198 234.34 2198 111.12 The following SAS program is submitted: proc sort data = employee_info; run;
Which one of the following BY statements completes the program and sorts the data sequentially by descending expense values within each descending IDNUMBER value?
- A. by descending IDNumber Expenses;
- B. by IDNumber descending Expenses descending;
- C. by descending IDNumber descending Expenses;
- D. by (IDNumber Expenses) descending;
Answer: C
NEW QUESTION 92
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 WORKTOTAL data set contains 500 observations.
- B. The program fails to execute due to errors.
- C. The WORKTDTAL data set contains 100 observations.
- D. The WORK.TOTAL data set contains 5 observations.
Answer: D
NEW QUESTION 93
Given the SAS data set EMPLOYEES:
EMPLOYEES
NAME SALARY
-------- ------------
Innis 60000
Jolli 50000
Ellis 55000
Liu 45000
The following SAS program is submitted:
proc print data = employees; where name like '_i%';
run;
What is contained in the output?
- A. Innis, Ellis, and Liu only
- B. Innis, Jolli, Ellis, and Liu
- C. Liu only
- D. Innis and Ellis only
Answer: C
NEW QUESTION 94
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
airplanetype = 'Large' and staff = 10;
else airplanetype = 'Small' and staff = 5;
run; - B. 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; - C. data work.test;
capacity = 150;
if 100 le capacity le 200 then;
airplanetype = 'Small';
staff = 5;
else;
airplanetype = 'Large';
staff = 10;
run; - D. 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;
Answer: D
NEW QUESTION 95
Which program will create a comma delimited raw data file (CSV)?
Answer:
Explanation:
Pending
NEW QUESTION 96
The data set WORK.REALESTATE has the variable LocalFee with a format of 9. and a variable CountryFee with a format of 7.; The following SAS program is submitted:
What are the formats of the variables LOCALFEE and COUNTRYFEE in the output dataset?
- A. LocalFee has format of 9. and CountryFee has a format of percent7.2
- B. The data step fails execution; there is no format for LocalFee.
- C. Both LocalFee and CountryFee have a format of percent7.2
- D. LocalFee has format of 9. and CountryFee has a format of 7.
Answer: C
NEW QUESTION 97
The following SAS program is submitted:
data work.month;
date = put('13mar2000'd,ddmmyy10.);
run;
Which one of the following represents the type and length of the variable DATE in the output data set?
- A. character, 8 bytes
- B. numeric, 10 bytes
- C. numeric, 8 bytes
- D. character, 10 bytes
Answer: D
NEW QUESTION 98
The following SAS program is submitted:
What new variables are created?
- A. Patients1, Patients2 and Patients3
- B. Difcount1, Difcount2 and Difcount3
- C. Diff1, Diff2 and Diff3
- D. Janpt, Febpt, and Marpt
Answer: B
NEW QUESTION 99
Given the SAS data set WORK.ORDERS:
The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".
Which of the following statement will correctly create the value and assign it to ship_note?
- A. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);
- B. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);
- C. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);
- D. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);
Answer: A
NEW QUESTION 100
Given the SAS data set WORK.TEMPS:
The following program is submitted:
Which output is correct?
- A. Option C
- B. Option D
- C. Option B
- D. Option A
Answer: A
NEW QUESTION 101
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. The SUM statement produces only subtotals of NUMBER for each value of TYPE.
- C. The SUM statement produces both a grand total of NUMBER and subtotals of NUMBER for each value of TYPE.
- D. Nothing is produced by the SUM statement; the program fails to execute.
Answer: A
Explanation:
Section: Volume A
NEW QUESTION 102
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 WORKTOTAL data set contains 500 observations.
- B. The program fails to execute due to errors.
- C. The WORKTDTAL data set contains 100 observations.
- D. The WORK.TOTAL data set contains 5 observations.
Answer: D
NEW QUESTION 103
Given the SAS data set SASDATA TWO:
SASDATA TWO
X Y
-- --
5 2
3 1
5 6
The following SAS program is submitted:
data sasuser.one two sasdata.three;
set sasdata two;
if x = 5 then output sasuser.one;
else output sasdata two;
run;
What is the result?
- A. No data sets are output.
The DATA step fails execution due to syntax errors. - B. data set SASUSER.ONE has 2 observations
data set SASUSER.TWO has 2 observations
data set WORK.OTHER has 5 observations - C. data set SASUSER.ONE has 5 observations
data set SASUSER.TWO has 5 observations
data set WORK.OTHER has 3 observations - D. data set SASUSER.ONE has 2 observations
data set SASUSER.TWO has 2 observations
data set WORK.OTHER has 1 observations
Answer: C
NEW QUESTION 104
A raw data file is listed below:
RANCH,1250,2,1,Sheppard Avenue,"$64,000"
SPLIT,1190,1,1,Rand Street,"$65,850"
CONDO,1400,2,1.5,Market Street,"80,050"
TWOSTORY,1810,4,3,Garris Street,"$107,250"
RANCH,1500,3,3,Kemble Avenue,"$86,650"
SPLIT,1615,4,3,West Drive,"94,450"
SPLIT,1305,3,1.5,Graham Avenue,"$73,650"
The following SAS program is submitted using the raw data file as input:
data work.condo_ranch;
infile 'file-specification' dsd;
input style $ @;
if style = 'CONDO' or style = 'RANCH' then
input sqfeet bedrooms baths street $ price : dollar10.; run;
How many observations does the WORK.CONDO_RANCH data set contain?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: A
NEW QUESTION 105
Given the raw data file EMPLOYEE:
----I----1 0---I----20---I----30
Ruth 39 11
Jose 32 22
Sue 30 33
John 40 44
The following SAS program is submitted:
data test;
infile 'employee';
input employee_name $ 1-4;
if employee_name = 'Ruth' then input idnum 10-11;
else input age 7-8;
run;
What value does the variable IDNUM contain when the name of the employee is "Ruth"?
- A. 0
- B. 1
- C. 2
- D. (missing numeric value)
Answer: C
NEW QUESTION 106
The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
WORK.EMPLOYEE WORK.SALARY fname age fname salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata; merge work.employee work.salary; by fname; totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
- A. 0
- B. No variables are output to the data set as the program fails to execute due to errors
- C. 1
- D. 2
Answer: A
NEW QUESTION 107
......
Get Perfect Results with Premium A00-211 Dumps Updated 275 Questions: https://passleader.examtorrent.com/A00-211-prep4sure-dumps.html
