A00-212日本語 by SASInstitute Actual Free Exam Questions And Answers

Question 1

% micro cols1;
name age;
% mend;
% macro cols2;
height weight
% mend
proc print data=sashelp.class;
<insert VAR statement here>
Run

A. var %cols1 height;

B. var heigh %cols1;

C. var %cols1 %cols2 height;

D. var %cols2 %cols1;

Discussion 0

Correct Answer: B Vote an answer

Question 2

SASHELP.CLASS
NAME AGE
Mary 15
Philip 16
Robert 12
Ronald 15

% let value = Philip;
proc print data =sashelp.class;
<insert Where statement here>
run;

A. Where upcase(name)="upcase(&value)";

B. Where upcase(name)="%upcase(&value)";

C. Where upcase(name)=%upcase(&value);

D. Where upcase(name)=upcase(&value);

Discussion 0

Correct Answer: B Vote an answer

Question 3

ONE
LEVEL AGE
1 10
2 20
3 20
2 10
1 10
2 30
3 10
2 20
3 30
1 10

proc sql;
select level, max(age) as MAX
from one
group by level
having max(age) > (select avg(age) from one);
quit;

A. LEVEL AGE
2 20
3 20

B. LEVEL AGE
2 30
3 30

C. LEVEL MAX
2 20
3 30

D. LEVEL MAX
2 30
3 30

Discussion 0

Correct Answer: D Vote an answer

Question 4

A. Into : GROUPS delimited by ' , '

B. : into GROUPS delimited by ' , '

C. into : GROUPS separated by ' , '

D. : into GROUPS separated = ' , '

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

A. DICTIONARY.TABLES

B. DICTIONARY.COLUMNS

C. DICTIONARY.VARIABLES

D. DICTIONARY.MEMBERS

Discussion 0

Correct Answer: B Vote an answer

Question 6

Data combine;
Merge one two;
By id;
Run;

A. proc sql;
Create table combine as
Select coalesce (one.id, two.id) as id,
Name,salary from one, two where one.id=two.id;
Quit;

B. proc sql;
Create table combine as
Select one.id,name,salary from one inner join two on one.id=two.id
Quit

C. proc sql;
Create table combine as
Select coalesce (one id, two id) as id,
Name,salary from one full join two on one.id=two.id;
Quit;

D. proc sql;
Create table combine as
Select one.id,
Name, salary from one full join two where one.id=two.id;
Quit

Discussion 0

Correct Answer: C Vote an answer

Question 7

A. CHECK

B. FORMAT

C. DISTINCT

D. UNIQUE

Discussion 0

Correct Answer: A Vote an answer

Question 8

CORRECT TEXT

% macro check(num=4);
% let result=%sysevalf(&num+0.5);
% put result is &result;
% mend;
% check(num=10)

A. result is 10+0.5

B. result is 10

C. result is

D. result is 10.5

Discussion 0

Correct Answer: D Vote an answer

Question 9

A. MAUTOLOCDISPLAY

B. MPRINT

C. MLOGIC

D. MPRINTNEST

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

A. Option B

B. Option A

C. Option D

D. Option C

Discussion 0

Correct Answer: A Vote an answer

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

Contact Us

Useful Links

Latest Updated