最新的SASInstitute A00-202免費考試真題

問題1

Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D
The following SAS program is submitted creating the output table THREE:
proc sql;
create table three as
select one.num, char1, char2
from one, two
where one.num = two.num; quit;
THREE NUM CHAR1 CHAR2
2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2
Which one of the following DATA step programs creates an equivalent SAS data set THREE?

A. data three;
set one;
set two;
by num;
run;

B. data three;D.data three;
set one;
do i = 1 to numobs;
set two(rename = (num = num2)) point = i
nobs = numobs;
if num2 = num then output;
end;
drop num2;
run;

C. data three;
merge one two;
by num;
run;

D. data three;C.data three;
merge one (in = in1) two (in = in2);
by num;
if in1 and in2;
run;

正確答案: B

問題2

Which one of the following options is available for SAS macro debugging?

A. MSGLEVEL

B. MLOGIC

C. MDEBUG

D. MAUTOSOURCE

正確答案: B

問題3

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

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

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

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

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

正確答案: D

問題4

The following SAS program is submitted:
data temp;
array points{2,3}_temporary_;
run;
Which one of the following is the maximum number of elements that are stored?

A. 3

B. 2

C. 5

D. 6

正確答案: D

問題5

Given the following SAS data set ONE:
ONE GROUP SUM
A 765 B 123 C 564
The following SAS program is submitted:
data _null_;
set one;
call symput(group,sum); run;
Which one of the following is the result when the program finishes execution?

A. Macro variable GROUP has a value of 1452.

B. Macro variable C has a value of 564.

C. Macro variable C has a value of 1452.

D. Macro variable GROUP has a value of 564.

正確答案: B

問題6

Which of the following statement(s) in the DATASETS procedure alters the name of a SAS data set stored in a SAS data library?

A. CHANGE statement only

B. MODIFY and CHANGE statements

C. MODIFY and RENAME statements

D. RENAME statement only

正確答案: A

問題7

Which one of the following should be avoided when creating and using an SQL procedure view?

A. referencing a view multiple times in the same program

B. creating views on tables whose structures remain constant

C. using summary functions

D. using a HAVING clause

正確答案: A

問題8

Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT LOCATION SUM
USA 30 EUR 40
The following SAS program is submitted:
%let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc"; quit;
Which one of the following is the result when the above code is executed on the above data set?

A. No report is generated as the case of the macro variable name is different.

B. A report is generated with one destination.

C. No report is generated as the case of the compared values is different.

D. A report is generated with the two original observations as the where clause does not work.

正確答案: C

最新的SASInstitute SAS advanced programming - A00-202免費考試真題

聯系我們

站內鏈接

最新更新