SAS Institute A00-211 SAS Base Programming for SAS 9 Online Training
SAS Institute A00-211 Online Training
The questions for A00-211 were last updated at Jan 04,2025.
- Exam Code: A00-211
- Exam Name: SAS Base Programming for SAS 9
- Certification Provider: SAS Institute
- Latest update: Jan 04,2025
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 named WORKSALARY contains 10 observations for each department, and is currently ordered by DEPARTMENT.
Which statement is true?
- A . The BY statement in the DATA step causes a syntax error.
- B . The statement payroll + wagerate; in the DATA step causes a syntax error.
- C . The values of the variable PAYROLL represent the total for each department in the WORK.SALARY data set.
- D . The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORKSALARY data set.
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 = left(dept) II number;
- C . department = trim(dept) number;
- D . department=trim(dept)||put(number,3.);
Given the SAS data set WORKAWARDS:
WORK.AWARDS
FNAMEPOINTSMONTH
———————————-
Amy24
Amy17
Gerard33
Wang33
Wang112
Wang18
The following SAS program is submitted:
proc sort data = work.awards;
by descending fname points;
run;
How are the observations sorted?
- A . ENAME POINTS MONTH
Wang33
Wang112
Wang18
Gerard33
Amy24
Amy17 - B . ENAME POINTS MONTH
Amy24
Amy17
Gerard33
Wang33
Wang18
Wang112 - C . ENAME POINTS MONTH
Wang33
Wang18
Wang112
Gerard33
Amy24
Amy17 - D . ENAME POINTS MONTH
Wang112
Wang18
Wang33
Gerard33
Amy17
Amy24
The following SAS program is submitted:
How will the Exam variable value be displayed in the FREQ procedure output?
- A . Fail
- B . Pass
- C . 50.5
- D . .(missing numeric value)
The following SAS program is submitted:
<insert ODS statement here>
proc means data = sasuser.shoes;
where product in (‘Sandal’ , ‘Slipper’ , ‘Boot’);
run;
<insert ODS statement here>
Which ODS statements complete the program and send the report to an HTML file?
- A . ods html = ‘sales.html’;
ods html close; - B . ods file = ‘sales.html’;
ods file close; - C . ods file html = ‘sales.html’;
ods file close; - D . ods html file = ‘sales.html’;
ods html close;
The following SAS program is submitted:
The program fails execution due to syntax errors.
What is the cause of the syntax error?
- A . The variable MONTHSALES does not exist.
- B . An array cannot be referenced on a KEEP data set option.
- C . The KEEP= data set option should be (KEEP = MONTHSALES).
- D . The KEEP= data set option should be the statement KEEP MONTHSALES{12}.
The following SAS program is submitted:
data WORK.ONE;
Text=’Australia, US, Denmark’;
Pos=find (Text,’US’,’i’,5);
run;
What value will SAS assign to Pos?
- A . 0
- B . 1
- C . 2
- D . 12
The following SAS program is submitted:
data work.flights;
destination = ‘cph’;
select(destination);
when(’LHR’) city = ‘London’;
when(’CPH’) city = ‘Copenhagen’;
otherwise city = ‘Other’;
end;
run;
What is the value of the CITY variable?
- A . Other
- B . Copenh
- C . Copenhagen
- D . ‘‘(missing character value)
After a SAS program is submitted, the following is written to the SAS log:
105 data january;
106 set allmonths(keep = product month num_sold cost);
107 if month = ‘Jan’ then output january;
108 sales = cost * num_sold;
109 keep = product sales;
——
22
ERROR 22-322: Syntax error, expecting one of the following:!, !!, &, *,**, +, -,/, <,< =, <>, =, >, ><, >=,
AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOTIN, OR,^=,|,II,
110 run;
What changes should be made to the KEEP statement to correct the errors in the LOG?
- A . keep product sales;
- B . keep product, sales;
- C . keep = product, sales;
- D . keep = (product sales);
The following SAS program is submitted:
data one;
date = ‘04juI2005’d;
format date weekdate.; run;
proc print data = one; run;
What output is generated?
- A . Obs date
1 Monday, July 4, 2005 - B . Obs date
1 July4, 2005 - C . Obs date
1 04Jul2005 - D . Obs date
1 Monday, 07/04/2005
Latest A00-211 Dumps Valid Version with 270 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
