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 01,2025.
- Exam Code: A00-211
- Exam Name: SAS Base Programming for SAS 9
- Certification Provider: SAS Institute
- Latest update: Jan 01,2025
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
Alfred 14
Alice 13
Barbara 13
Carol 14 - B . —- I—-10—I—-20—I—-30
Alfr14
Alic13
Barb13a
Carol 4 - C . —-I—-10—I—-20—I—-30
Alfr14ed
Alic130
Barb13ara
Caro141 - D . —-I—-10—I—-20—I—-30
Alfred14
Alice13
Barbara13
Carol14
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
Alfred 14
Alice 13
Barbara 13
Carol 14 - B . —- I—-10—I—-20—I—-30
Alfr14
Alic13
Barb13a
Carol 4 - C . —-I—-10—I—-20—I—-30
Alfr14ed
Alic130
Barb13ara
Caro141 - D . —-I—-10—I—-20—I—-30
Alfred14
Alice13
Barbara13
Carol14
00100.00
Total10100.00
Which option correctly completes the program and creates the report?
- A . LIST
- B . NOCOLS
- C . CROSSLIST
- D . NOCROSSTAB
Given the contents of the raw data file TYPECOLOR:
—-I—-10—I—-20—I—-30
Daisyyellow
The following SAS program is submitted:
data flowers;
infile ‘typecolor’;
input type$ 1-5+1 color$;
run;
What are the values of the variables TYPE and COLOR?
- A . type colordaisygreen
- B . type colordaisy ellow
- C . type colordaisyyellow” “(missing character value)
- D . No values are stored for the TYPE and COLOR variables.
Given the contents of the raw data file EMPLOYEE:
—-|—-10—-|—-20—-|—-30
Alan
19/2/2004
ACCT
Rob
22/5/2004
MKTG
MaryJane
14/3/2004
EDUC
The following SAS program is submitted:
data emps;
infile ‘employee’;
input@1 name$
@15 date <insert INFORMAT here>
@25 department$;
run;
Which INFORMAT correctly completes the program?
- A . date9.
- B . ddmmyyyy9.
- C . ddmmyy10.
- D . ddmmyyyy10.
The following SAS program is submitted:
libname temp ‘SAS data library’;
data work.new;
set temp.jobs;
format newdate mmddw10.;
mdate = month(newdate);
ddate = weekday(newdate);
run;
proc print data = work.new; run;
The variable NEWDATE contains the SAS date value for April 15. 2005.
What output is produced if April 15, 2005 falls on a Friday?
- A . Obsnewdate mdate ddate104/15/2005 APR 6
- B . Obs newdate mdate ddate104/15/2005 4 6
- C . Obs newdate mdate ddate104/15/2005 APR 7
- D . Obs newdate mdate ddate104/15/2005 4 7
Given the following data step:
After data step execution, what will data set WORK.GEO contain?
- A . Option A
- B . Option B
- C . Option C
- D . Option D
Given the SAS data set AGES:
AGES
AGE
———
The variable AGE contains character values. The following SAS program is submitted:
data subset;
set ages;
where age> 12;
run;
How many observations are written out to the data set SUBSET?
- A . 0
- B . 1
- C . 2
- D . 3
The following SAS program is submitted:
footnote1 ‘Sales Report for Last Month’;
footnote2 ‘Selected Products Only’;
footnote3 ‘All Regions’;
footnote4 ‘All Figures in Thousands of Dollars’; proc print data = sasuser.shoes; footnote2 ‘All Products’;
run;
Which footnote(s) is/are displayed in the report?
- A . All Products
- B . Sales Report for Last Month All Products
- C . All Products All Regions All Figures in Thousands of Dollars
- D . Sales Report for Last Month All Products All Regions All Figures in Thousands of Dollars
The following SAS program is submitted:
Data_null_;
set old;
put sales 1 sales2;
run;
Where is the output written?
- A . to the SAS log
- B . to the SAS data set _NULL_
- C . to the SAS output window or to an output file
- D . to the raw data file that was most recently opened