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

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

Show Answer 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

Show Answer 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

Show Answer 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

Show Answer Next Question

QUESTION: 65

Which one of the following statements is true?

The WHERE statement can be executed conditionally as part of an IF statement.
The WHERE statement selects observations before they are brought into the PDV.
The subsetting IF statement works on observations before they are read into the PDV.
The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.

Answer(s): B

Show Answer Next Question

Free A00-212 Exam Braindumps SAS Advanced Programming Exam for SAS 9 Questions 61–65 (page: 14)

QUESTION: 61

QUESTION: 62

QUESTION: 63

QUESTION: 64

QUESTION: 65

Free A00-212 Exam Braindumps
SAS Advanced Programming Exam for SAS 9 Questions 61–65 (page: 14)