A00-212日本語試験無料問題集（185題）「SASInstitute SAS Advanced Programming Exam for SAS 9 (A00-212日本語版) 認定」

出題：1

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

B. 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;

C. 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;

D. proc sql;
select product.*, cost.unitcost, sales.quantity
from product, cost, sales
where product.item = cost.item and
product.item = sales.item;
quit;

正解：A 解答を投票する

出題：2

proc contents data = testdata.one;
run;

A. proc sql;
show testdata.one;
quit;

B. proc sql;
describe testdata.one;
quit;

C. proc sql;
show table testdata.one;
quit;

D. proc sql;
describe table testdata.one;
quit;

正解：D 解答を投票する

出題：3

A. CHECK

B. DISTINCT

C. UNIQUE

D. FORMAT

正解：A 解答を投票する

出題：4

A. Option D

B. Option C

C. Option A

D. Option B

正解：B 解答を投票する

出題：5

A. Option D

B. Option C

C. Option A

D. Option B

正解：D 解答を投票する

出題：6

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

proc sql;
select country, city, sum(visit) as TOTAL
from one
group by country, city
order by country, total desc;
quit;

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

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

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

D. COUNTRY CITY TOTAL
USA BOSTON 50

正解：A 解答を投票する

出題：7

A. Option D

B. Option C

C. Option A

D. Option B

正解：B 解答を投票する

出題：8

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