QUESTION: 61

The following SAS program is submitted:

data one;
do i = 1 to 10;
ptobs = ceil(ranuni(0) * totobs);
set temp point = ptobs
nobs = totobs;
output;
end;
stop;
run;

The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

any integer between 1 and 10
any real number between 0 and 1
any integer between 1 and 2,500,000
any real number between 1 and 2,500,000

Answer(s): C

Reveal Solution Next Question

QUESTION: 62

Which one of the following programs contains a syntax error?

proc sql;
select product.*, cost.unitcost, sales.quantity
from product p, cost c, sales s
where p.item = c.item and p.item = s.item;
quit;
proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;
proc sql;
select p.*, c.unitcost, s.quantity
from product as p, cost as c, sales as s
where p.item = c.item and p.item = s.item;
quit;
proc sql;
select p.*, c.unitcost, s.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;

Answer(s): D

Reveal Solution Next Question

QUESTION: 63

The following SAS code is submitted:

%macro houses(dsn = houses,sub = RANCH);
data &dsn;
set sasuser.houses;
if style = "¬";
run;
%mend;
%houses(sub = SPLIT)
%houses(dsn = ranch)
%houses(sub = TWOSTORY)

Which one of the following is the value of the automatic macro variable SYSLAST?

work.ranch
work.houses
WORK.RANCH
WORK.HOUSES

Answer(s): D

Reveal Solution Next Question

QUESTION: 64

Given the following SAS data sets ONE and TWO:

ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN

The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;

Which one of the following reports is generated?

COUNTRY GERMANY JAPAN
COUNTRY FRANCE BELGIUM
COUNTRY CANADA FRANCE BELGIUM
COUNTRY CANADA FRANCE GERMANY

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 17)

QUESTION: 61

QUESTION: 62

QUESTION: 63

QUESTION: 64

Exam Discussions & Posts