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

Reveal Solution 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

Reveal Solution 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;

Answer(s): A

Reveal Solution Next Question

QUESTION: 80

Which one of the following automatic SAS macro variables contains the return code from a previously executed step?

&RC
&ERR
&SYSRC
&SYSERR

Answer(s): D

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 20)

QUESTION: 77

QUESTION: 78

QUESTION: 79

QUESTION: 80