Free A00-212 Exam braindumps download (A00-212 exam dumps Free)

QUESTION: 76

Given the following SAS data set ONE:

ONE
GROUP SUM
A 765
B 123
C 564
The following SAS program is submitted:
data _null_;
set one;
call symput(group,sum);
run;

Which one of the following is the result when the program finishes execution?

Macro variable C has a value of 564.
Macro variable C has a value of 1452.
Macro variable GROUP has a value of 564.
Macro variable GROUP has a value of 1452.

Answer(s): A

Show Answer Next Question

QUESTION: 77

The SAS data set ONE consists of five million observations and has 25 variables. Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

data two;
set one;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
if totrev > 1000;
run;
data two;
set one;
totrev = sum(price * quantity);
if totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
data two;
set one;
totrev = sum(price * quantity);
where totrev > 1000;
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;
data two;
set one;
where totrev > 1000;
totrev = sum(price * quantity);
totcost = sum(fixed,variable);
profit = sum(totrev,otcost);
run;

Answer(s): B

Show Answer Next Question

QUESTION: 78

Given the following SAS data set ONE: ONE
ONE
COUNTRY CITY VISIT
USA BOSTON 10
UK LONDON 5
USA DALLAS 10
UK MARLOW 10
USA BOSTON 20
UK LONDON 15
USA DALLAS 10
The following SAS program is submitted:
proc sql;
select country, city, sum(visit) as TOTAL
from one
group by country, city
order by country, total desc;
quit;

Which one of the following reports is generated?

COUNTRY CITY TOTAL
UK MARLOW 10
UK LONDON 20
USA BOSTON 50
USA DALLAS 20
COUNTRY CITY TOTAL
UK LONDON 20
UK MARLOW 10
USA BOSTON 50
USA DALLAS 20
COUNTRY CITY TOTAL
USA BOSTON 50
COUNTRY CITY TOTAL
UK MARLOW 10
UK LONDON 20
USA DALLAS 20
USA BOSTON 50

Answer(s): B

Show Answer Next Question

QUESTION: 79

Given the following SAS data sets ONE and TWO:

ONE TWO
NUM CHAR1 NUM CHAR2
1 A 2 X
2 B 3 Y
4 D 5 V

The following SAS program is submitted creating the output table THREE:
data three;
set one two;
run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V

Which one of the following SQL programs creates an equivalent SAS data set THREE?

proc sql;
create table three as
select *
from one
outer union corr
select *
from two;
quit;
proc sql;
create table three as
select *
from one
outer union
select *
from two;
quit;
proc sql;
create table three as
select *
from one
outer union
select *
quit;
proc sql;
create table three as
select *
from one
union corr
select *
from two;
quit;