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 Dec 29,2024.
- Exam Code: A00-211
- Exam Name: SAS Base Programming for SAS 9
- Certification Provider: SAS Institute
- Latest update: Dec 29,2024
The following SAS program is submitted:
data WORK.ACCOUNTING;
set WORK.DEPARTMENT;
label Jobcode=’Job Description’;
run;
Which statement is true about the output dataset?
- A . The label of the variable Jobcode is Job (only the first word).
- B . The label of the variable Jobcode is Job Desc (only the first 8 characters).
- C . The label of the variable Jobcode is Job Description.
- D . The program fails to execute due to errors. Labels must be defined in a PROC step.
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
- A . 0
- B . 5
- C . 7
- D . 12
The following SAS program is submitted:
data work.empsalary;
set work.people (in = inemp)
work.money (in = insal);
if insal and inemp;
run;
The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7 observations.
How many observations will the data set WORK.EMPSALARY contain?
- A . 0
- B . 5
- C . 7
- D . 12
1941 1
The following SAS program is submitted:
data coins;
infile ‘yearamt’;
input year quantity;
<insert statement(s) here>
run;
Which statement(s) completed the program and produced a non-missing value for the variable TOTQUANTITY in the final observation of the output data set?
- A . totquantity + quantity;
- B . totquantity = sum(totquantity + quantity);
- C . retain totquantity; totquantity = totquantity + quantity;
- D . retain totquantity0; totquantity = totquantity + quantity;
The following SAS program is submitted:
libname temp ‘SAS data library’;
data temp.sales;
merge temp.sales
work.receipt;
by names;
run;
The input data files are sorted by the NAMES variable:
What is the result?
- A . The program executes successfully and a temporary SAS data set is created.
- B . The program executes successfully and a permanent SAS data set is created.
- C . The program fails execution because the same SAS data set is referenced for both read and write operations.
- D . The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.
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
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
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
Latest A00-211 Dumps Valid Version with 270 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
