SAS Certification Exams

Testinside sas a00-212

Posted September 26th, 2008 by PassGuide.com-Free Braindumps Bootcamp

SAS Advanced Programming Exam for SAS 9 : A00-212 Exam

Exam Number/Code: A00-212
Exam Name: SAS Advanced Programming Exam for SAS 9
Questions and Answers: 130 Q&As
Price: $125.00
Update Time: 2008-6-23

“SAS Advanced Programming Exam for SAS 9″, also known as A00-212 exam, is a SAS Institute certification.
Preparing for the A00-212 exam? Searching A00-212 Test Questions, A00-212 Practice Exam, A00-212 Dumps?

Free A00-212 Demo Download
Exam Name: SAS Advanced Programming Exam for SAS 9
Exam Type SAS
Exam Code: A00-212 Total Questions: 66

Question: 1
Given the SAS data set ONE:

ONE
NUM VAR
—— ——–
1 A
2 B
3 C

Which SQL procedure program deletes the data set ONE?

A. proc sql;
delete table one;
quit;
B. proc sql;
remove table one;
quit;
C. proc sql;
drop table one;
quit;
D. proc sql;
delete from one;
quit;
Answer: C

Question: 2
Which SET statement option names a variable that contains the number of the observation to
read during the current iteration of the DATA step?

A. OBS = pointobs
B. KEY = pointobs
C. NOBS = pointobs
D. POINT = pointobs

Answer: D

Question: 3
Given the SAS data sets CLASS1 and CLASS2:

CLASS1 CLASS2
NAME COURSE NAME COURSE
——- ———– ——– ————-
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hillier MATH2

The following SAS program is submitted:

proc sql;
select name from CLASS1

select name from CLASS2;

quit;
The following output is desired:
NAME
——–
Chang
Chang
Lauren

Which SQL set operator completes the program and generates the desired output?

A. UNION ALL
B. EXCEPT ALL
C. INTERSECT ALL
D. OUTER UNION ALL

Answer: B

Question: 4
Which of the following is true about the COMPRESS= YES data set option?

A. It uses the Ross Data Compression method to compress numeric data.
B. It is most effective with character data that contains repeated characters.
C. It is most effective with numeric data that represents large numeric values.
D. It is most effective with character data that contains patterns, rather than simple repetitions.

Answer: B

Question: 5
The following SAS program is submitted:

options reuse = YES;
data sasuser.RealEstate(compress = CHAR);
set sasuser.houses;
run;

What is the effect of the REUSE = YES SAS system option?

A. It allows updates in place.
B. It tracks and recycles free space.
C. It allows a permanently stored SAS data set to be replaced.
D. It allows users to access the same SAS data set concurrently.

Answer: B

Question: 6
Given the SAS data sets ONE and TWO:

ONE TWO
ID NAME ID SALARY
— ——- — ————
112 Smith 243 150000
243 Wei 355 45000
457 Jones 523 75000

The following SAS program is submitted:
data combine;
merge one two;
by id;
run;

Which SQL procedure program produces the same results?

A. proc sql;
create table combine as
select coalesce(one.id, two.id) as id,
name,
salary
from one full join two
on one.id = two.id;
quit;
B. proc sql;
create table combine as
select one.id,
name,
salary
from one inner join two
on one.id = two.id;
quit;
C. proc sql;
create table combine as
select coalesce(one.id, two.id) as id,
name,
salary
from one, two
where one.id = two.id;
quit;
D. proc sql;
create table combine as
select one.id,
name,
salary
from one full join two
where one.id = two.id;
quit;

Answer: A

Question: 7
The following SAS program is submitted:
%let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = “&lib”;
quit;
Several SAS data sets exist in the SASUSER library.
What is generated as output?

A. a report showing the numeric columns in each table in SASUSER
B. a report showing the number of columns in each table in SASUSER
C. a report showing the names of the columns in each table in SASUSER
D. a report showing the number of numeric columns in each table in SASUSER

Answer: B

Question: 8
Given the SAS data sets CLASS1 and CLASS2:
CLASS1 CLASS2
NAME COURSE NAME COURSE
——– ———– ——– ————
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Hillier MATH2
The following SAS program is submitted:
proc sql;
select name from CLASS1

select name from CLASS2;
quit;
The following output is desired:
NAME
——–
Chang
Lauren
Which SQL set operator completes the program and generates the desired output?

A. UNION
B. EXCEPT
C. INTERSECT
D. OUTER UNION CORR

Answer: B

Question: 9
Given the SAS dataset ONE
ONE
NAME SALARY
——- ———-
Hans 200
Maria 205
Jose 310
Ariel 523
The following SAS program is submitted:
proc sql;

from one;
quit;
The following output is desired:
SALARY BONUS
—————————-
200 20
205 20.5
310 31

TestInside offers free demo for A00-212 exam ( SAS Advanced Programming Exam for SAS 9). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.
Free down:PASS4SURE a00-212
Free down:TESTKING A00-212

Related Posts

• Testking A00-212 Exam SAS Advanced Programming for SAS 9

Related Posts

• Testking A00-212 Exam SAS Advanced Programming for SAS 9

Tags: a00-212