A00-212 Exam

Free A00-212 Demo Download

Just4braindumps.info offers free demo for SAS Institute Systems Certification 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.

Download PDF: A00-212 Demo

A00-212 Exam Description

It is well known that latest A00-212 exam test is the hot exam of SAS Institute certification. Just4braindumps.info offer you all the Q&A of the A00-212 real test . It is the examination of the perfect combination and it will help you pass A00-212 exam at the first time!

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


1. Which SAS procedure changes the name of a permanent format for a variable stored in a SAS data set?
A. MODIFY
B. FORMAT
C. REGISTRY
D. DATASETS
Answer: D

2. Given the SAS data set ONE:
ONEREP COST
SMITH 200
SMITH 400
JONES 100
SMITH 600
JONES 100
The following SAS program is submitted:
proc sql;
select rep, avg(cost) as AVERAGE
from one
group by rep;
quit;
The following output is desired:
REP AVERAGE
SMITH 400
Which SQL procedure clause completes the program and generates the desired output?
A. having avg(cost) < (select avg(cost) from one)
B. where avg(cost) > (select avg(cost) from one)
C. having avg(cost) > (select avg(cost) from one)
D. where calculated average > (select avg(cost) from one)
Answer: C

3. The following SAS program is submitted:
%let test = one;
%let one = two;
%let two = three;
%let three = last;
%put what displays is &&&&&test;
What is written to the SAS log?
A. what displays is one
B. what displays is two
C. what displays is three
D. what displays is last
Answer: B

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

5. The following SAS program is submitted:
proc contents data = testdata.one;
run;
Which SQL procedure program produces similar information about the column attributes of the dataset TESTDATA. ONE?
A. proc sql;
contents testdata.one;
quit;
B. proc sql;
describe testdata.one;
quit;
C. proc sql;
contents table testdata.one;
quit;
D. proc sql;
describe table testdata.one;
quit;
Answer: D