최신 A00-212 무료덤프 - SASInstitute SAS Advanced Programming Exam for SAS 9
A data set stored on a network drive has the following characteristics:
14 Million observations
400 numeric variables
0 character variables of length 20
Binary compression
A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to
reduce computer resource utilization in this DATA Step?
14 Million observations
400 numeric variables
0 character variables of length 20
Binary compression
A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to
reduce computer resource utilization in this DATA Step?
정답: B
The SAS data set WORK.TEMP is indexed on variable Id:
The following SAS program is submitted:
The following SAS program is submitted:
정답: B
At the start of a new SAS session; the following program is submitted:
% macro one;
data _null_;
call symput('proc','measn);
run;
proc &proc data=sashelp.class;
run;
% mend;
% one()
What is the result?
% macro one;
data _null_;
call symput('proc','measn);
run;
proc &proc data=sashelp.class;
run;
% mend;
% one()
What is the result?
정답: B
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?
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?
정답: C
Given the SAS data set ONE:
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
% let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
ONE
DIVISION SALES
A 1234
A 3654
B 5678
The following SAS program is submitted:
Data_null_;
Set one;
By divition;
If first.division then
Do;
% let mfirst=sales;
end;
run;
What is the value of the macro variable MFRIST when the program finishes execution?
정답: D
The following SAS program is submitted:
options mprint;
% macro test(parm);
proc &parm data = sashelp.prdsale;
run;
% mend;
% test(print)
What is the result of the MPRINT options?
options mprint;
% macro test(parm);
proc &parm data = sashelp.prdsale;
run;
% mend;
% test(print)
What is the result of the MPRINT options?
정답: B
The following SAS program is submitted:
proc datasets lib = testdata;
modify one;
label num = 'Number';
format num 4.;
quit;
Which one of the following SQL programs produces the same results as the above DATASETS procedure?
proc datasets lib = testdata;
modify one;
label num = 'Number';
format num 4.;
quit;
Which one of the following SQL programs produces the same results as the above DATASETS procedure?
정답: A
This question will ask you to provide a segment of missing code.
Given the two data sets on the left, the SAS program on the right is submitted.
In the text box in the program above, complete the program so that it will properly use the macro variable to select
the corresponding cities.
Case is ignored and standard SAS syntax rules apply.
Given the two data sets on the left, the SAS program on the right is submitted.
In the text box in the program above, complete the program so that it will properly use the macro variable to select
the corresponding cities.
Case is ignored and standard SAS syntax rules apply.
정답:
North Carolina
Given the data set shown in the left, the SAS program on the right is submitted.
Which program will result in the identical report?
Which program will result in the identical report?
정답: A
설명: (DumpTOP 회원만 볼 수 있음)
Which one of the following options is available for SAS macro debugging?
정답: C