問題1
data new (bufsize = 6144 bufno = 4);
set old;
run;
data new (bufsize = 6144 bufno = 4);
set old;
run;
正確答案: A
問題2
正確答案: D
問題3
正確答案: C
問題4
正確答案: C
問題5
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;
230 set sasuser.houses;
231 if style = 'RANCH' then output sasuser.ranch;
232 else if style = 'CONDO' then output sasuser.condo;
233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH.
NOTE: A stored DATA STEP view cannot run under a different operating system.
234
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
229 data sasuser.ranch sasuser.condo / view = sasuser.ranch;
230 set sasuser.houses;
231 if style = 'RANCH' then output sasuser.ranch;
232 else if style = 'CONDO' then output sasuser.condo;
233 run;
NOTE: DATA STEP view saved on file SASUSER.RANCH.
NOTE: A stored DATA STEP view cannot run under a different operating system.
234
235 proc print data = sasuser.condo;
ERROR: File SASUSER.CONDO.DATA does not exist.
236 run;
正確答案: C
問題6
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
ONE TWO
NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN
2 FRANCE 5 TOKYO
3 GERMANY 4 BELGIUM
5 JAPAN
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num);
quit;
正確答案: A
問題7
proc sort data = sales tagsort;
by month year;
run;
proc sort data = sales tagsort;
by month year;
run;
正確答案: C
問題8
正確答案: A
問題9
正確答案: D
問題10
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
% macro loop;
data one;
% do I=1 %to 3;
var&I=&I;%
end
run;
% mend;
% loop
(LOOP): Beginning execution
(LOOP): %DO loop beginning; index variable l; start value is 1; stop value is 3; by value is 1
(LOOP): %DO loop index variable l is now 2; loop will iterate again
(LOOP): %DO loop index variable l is no 3; loop will iterate again
(LOOP): %DO loop index variable l is no 4; loop will iterate again
(LOOP): Ending execution
正確答案: D
問題11
data temp;
length 1 b 3 x;
infile 'file reference';
input a b x;
run;
data temp;
length 1 b 3 x;
infile 'file reference';
input a b x;
run;
正確答案: D
問題12
ONE
DIVISION SALES
A 1234
A 3654
B 5678
data _null_;
set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
ONE
DIVISION SALES
A 1234
A 3654
B 5678
data _null_;
set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
正確答案: D
問題13
正確答案: B
說明：（僅 NewDumps 成員可見）
問題14
正確答案: C