최신 A00-212 무료덤프 - SASInstitute SAS Advanced Programming Exam for SAS 9

문제1

The question will ask you to provide a segment of missing code.
Given the following SAS program:

Which segment of code completes the program to use finance.new SAS view?

A. Data = finance.new / view = finance.new

B. View = finance.new

C. Data = finance.new

D. Data = finance.new / view

정답: B

문제2

The SAS data set ONE contains fifty million observations and contains the variable
PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV,
TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

A. data two;
Set one;
Totrev=sum(price*quantity);
If totrev>1000;
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;

B. data two;
Set one;
Where totrev>1000;
Totrev=sum(price*quantity);
Totcost=sum(fixed,variable);
Profit=sum(totrev,-totcost);
Run;

C. data two;
Set one;
Totrev = sum(price*quantity);
Totcost= sum(fixed,variable);
If totrev>1000;
Profit=sum(totrev,-totcost);
Run;

D. data two;
Set one;
totrev=sum(price*quantity);
where totrev>1000;
totcost=sum(fixed,variable);
profit=sum(totrev,-totcost);
run;

정답: A

문제3

This question will ask you to provide missing option.

Which option is required to complete the program correctly?

A. CAMPLIB

B. UTILLOC

C. FMTSEARCH

D. LIBREF

정답: D

문제4

In which one of the following SAS programs is the SAS data set index named CHAR1 always used?

A. proc sql;
create table three as
select *
from one, two
where one.char1 > two.char1;
quit;

B. data three;
set one;
where char1 in ('new york' 'los angeles');
run;

C. data three;
set one;
set two key = char1;
run;

D. data three;
set one;
if char1 in ('new york' 'los angeles');
run;

정답: C

문제5

Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

A. CONTENTS

B. MODIFY

C. DATASETS

D. FORMAT

정답: C

문제6

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:
Data combine;
Merge one two;
By id;
Run;
Which SQL procedure program procedures the same results?

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

정답: C

문제7

Given the following SAS data set SASUSER.HIGHWAY:
SASUSER.HIGHWAY
STEERING SEATBELT SPEED STATUS COUNT
absent no 0-29 serious 31
absent no 0-29 not 1419
absent no 30-49 serious 191
absent no 30-49 not 2004
absent no 50+ serious 216
The following SAS program is submitted:
% macro highway;
proc sql noprint;
select count(distinct status)
into :numgrp
from sasuser.highway;
% let numgrp = &numgrp;
select distinct status
into :group1-:group&numgrp
from sasuser.highway;
quit;
% do i = 1 %to &numgrp;
proc print data = sasuser.highway;
where status = "&&group&i" ;
run;
% end;
% mend;
% highway
How many reports are produced by the above program?

A. 1

B. 0

C. 2

D. 5

정답: C

문제8

Which SQL procedure program deletes rows from the data set CLASS?

A. proc sql;
Delete from class
Where age<(select stop_age from threshold);
Quit;

B. proc sql;
Alter from class
Delete where age<(select stop_age from threshold);
Quit;

C. proc sql;
Select * from class
Where age<(select stop_age from threshold);
Quit;

D. proc sql;
Modify table class
Delete where age<(select stop_age from threshold);
Quit

정답: A

문제9

The following SAS program is submitted:

The current system date macro variable is 30JUL2013.
Which output will be written to the log by the program?

A. In two years it will be: 2014+1+1

B. Error: Required operator not found in expression
in two years it will be: 2013+12+1

C. In two years it will be: 2014+1
0

D. In two years it will be: 2013+1+1+1

정답: A

문제10

The following SAS program is submitted:
data two;
y = '2';
run;
% let x = 10;
% let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;
Which one of the following is the value of the variable Z when the program finishes execution?

A. _ERROR_

B. . (missing numeric)

C. 20 (as a numeric)

D. 20 (as a character)

정답: C

최신 A00-212 무료덤프 - SASInstitute SAS Advanced Programming Exam for SAS 9

우리와 연락하기

유용한 링크

최신 업데이트