Your success in SAS Institute A00-212 is our sole target and we develop all our A00-212 braindumps in a way that facilitates the attainment of this target. Not only is our A00-212 study material the best you can find, it is also the most detailed and the most updated. A00-212 Practice Exams for SAS Institute A00-212 are written to the highest standards of technical accuracy.
Q1. The SAS data set ONE contains fifty million observations and contains the variable
PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?
A. data two;
Set one;
Where totrev>1000;
Totrev=sum(price*quantity);
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
B. data two;
Set one;
totrev=sum(price*quantity);
where totrev>1000;
totcost=sum(fixed,variable);
profit=sum(totrev,-totcost);
run;
C. data two;
Set one;
Totrev=sum(price*quantity);
If totrev>1000;
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;
D. data two;
Set one;
Totrev = sum(price*quantity);
Totcost= sum(fixed,variable);
If totrev>1000;
Profit=sum(totrev,-totcost);
Run;
Answer: C
Q2. Given the following SAS data set ONE:
ONE CATEGORY AGE SALARY BONUS
M 28 200 20
M 25 100 10
M 28 300 10
M 33 300 30
F 18 100 50
F 25 200 10
F 35 400 50
The following SQL program is submitted:
proc sql;
create table two as
select distinct age
from one
where age < 33;
quit;
How many rows are written to the SAS data set TWO?
A. 3
B. 4
C. 5
D. 6
Answer: A
Q3. The following SAS program is submitted:
%macro check(num=4);
%let result=%eval(&nm gt 5);
%put result is &result;
%mend;
%check (num=10)
What is written to the SAS log?
A. result is true
B. result is 10 gt 5
C. result is 1
D. result is 0
Answer: C
Q4. 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 table testdata.one;
Quit;
B. proc sql;
Describe table testdata.one;
Quit;
C. proc sql;
describe testdata.one;
Quit;
D. proc sql;
Contents testdata.one;
Quit;
Answer: B
Q5. The following SAS program is submitted:
%micro test(var);
%let jobs=BLACKSMITH WORDSMITH SWORDSMITH;
%let type=%index(&jobs,&var);
%put type = &type;
%mend;
%test(SMITH)
What is the value of the macro variable TYPE when the %PUT statement executes?
A. 0
B. Null
C. 6
D. 3
Answer: C
Q6. The SAS data set ONE contains the variables X,Y,Z and W.
The following SAS program is submitted:
Proc transpose data =one
Out=trans
Name=new;
By x;
var y;
run;
What are the names of all of the columns created by the TRANSPOSE procedure?
A. new, X,Y and _COL1_
B. new, X and COL1 only
C. new, Y and COL1 only
D. new, X and Y only
Answer: B
Q7. Given the SAS date sets CLASS1 and CLASS2
CLASS1 CLASS2
NAME COURSE NAME COURSE
Lauren MATH1 Smith MATH2
Patel MATH1 Farmer MATH2
Chang MATH1 Patel MATH2
Chang MATH3 Hiller MATH2
The following SAS program is submitted:
Proc sql;
Select name from CLASS1
<insert SQL set operator here>
select name from CLASS;
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
Q8. Given the following SAS data set ONE:
ONE LEVEL AGE 1 10 2 20 3 20 2 10 1 10 2 30 3 10 2 20 3 30 1 10
The following SAS program is submitted: proc sql;
select level, max(age) as MAX
from one
group by level
having max(age) > (select avg(age) from one);
quit;
Which one of the following reports is generated?
A. LEVEL AGE 2 20 3 20
B. LEVEL AGE 2 30 3 30
C. LEVEL MAX 2 20 3 30
D. LEVEL MAX 2 30 3 30
Answer: D