A00-212日本語 by SASInstitute Actual Free Exam Q&As

Question 1

Discussion 0

Correct Answer:

CORR
Explanation:
Reference:
http://www.koerup.dk/Cert/0104/010405/010405.html

Question 2

A. Data = finance.new / view = finance.new B. Data = finance.new C. View = finance.new D. Data = finance.new / view

Discussion 0

Correct Answer: C Vote an answer

Question 3

A. Name Age Weight Height B. Height Weight Name Age C. Weight Height Name Age D. Weight Height

Discussion 0

Correct Answer: A Vote an answer

Question 4

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: C Vote an answer

Question 5

data temp:
array points { 2,3 } (10,15,20,25,30,35);
run;

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: D Vote an answer

Question 6

ONE
SALARY
200
205
523

Proc sql;
Select * from one
<Insert Where expression here>;
quit;

SALARY
200
205
523

A. Where salary is not B. Where salary ne missing C. Where salary is not missing D. Where salary ne null

Discussion 0

Correct Answer: C Vote an answer

Question 7

ONE TWO
# Variable Type Len Pos # Variable Type Len Pos
2 sales Num 8 8 2 budget Num 8 8
1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0

data three;
merge one two;
by year;
run;

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: C Vote an answer

Question 8

A. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit; B. data three;
set one;
if char1 in ('new york' 'los angeles');
run; C. data three;
set one;
set two key = char1;
run; D. data three;
set one;
where char1 in ('new york' 'los angeles');
run;

Discussion 0

Correct Answer: C Vote an answer

Question 9

data new(bufsize = 6144 bufno = 4);
set old;
run;

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: A Vote an answer

Question 10

% macro test(var);
% let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
% let type = %index(&jobs,&var);
% mend;
% test(SMITH)

A. 3 B. 6 C. 0 D. null

Discussion 0

Correct Answer: B Vote an answer

Question 11

proc sort data=WORK.CHECK;
by Code;
run;

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: C Vote an answer

Question 12

ONE
NUM VAR
1 A
2 B
3 C

A. proc sql;
drop table one;
quit; B. proc sql;
alter table one
drop num, var;
quit; C. proc sql;
delete table one;
quit; D. proc sql;
delete from one;
quit;

Discussion 0

Correct Answer: A Vote an answer

Question 13

data two;
y = '2';
run;
% let x = 10;
% let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;

A. _ERROR_ B. . (missing numeric) C. 20 (as a numeric) D. 20 (as a character)

Discussion 0

Correct Answer: C Vote an answer

Question 14

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

A. Option D B. Option A C. Option B D. Option C

Discussion 0

Correct Answer: D Vote an answer

SASInstitute SAS Advanced Programming Exam for SAS 9 (A00-212日本語版) - A00-212日本語 Exam Practice Test