SASInstitute A00-212日本語 問題集

質問 1：

A. DATASETS
B. FORMAT
C. CONTENTS
D. MODIFY
正解：A

質問 2：

% let lib=%upcase(sauser); proc sql;
select nvar form dictionary.tables where libname='&lib"; quit;
Several SAS data sets exist in the SAUSER library.

A. A report showing the number of columns in each table in SASUSER
B. A report showing the numeric columns in each table in SASUSER
C. A report showing the names of the columns in each table in SASUSER
D. A report showing the number of numeric columns in each table in SASUSER
正解：A

質問 3：



A. Option A
B. Option C
C. Option D
D. Option B
正解：C

質問 4：

data two;
y = '2';
run;
% let x = 10;
% let var = y;
data one;
set two (keep = &var);
z = &var * &x;
run;

A. _ERROR_
B. 20 (as a character)
C. 20 (as a numeric)
D. . (missing numeric)
正解：C

質問 5：

ONE
REP AREA COST
SMITH NORTH 100
SMITH SOUTH 200
JONES EAST 100
SMITH NORTH 300
JONES WEST 100
JONES NORTH 200
JONES NORTH 400
SMITH NORTH 400
JONES WEST 100
JONES WEST 300

proc sql;
select rep, area, count(*) as TOTAL
from one
group by rep, area;
quit;

A. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
B. REP AREA TOTAL
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
C. REP AREA TOTAL
JONES EAST 1
JONES NORTH 2
JONES WEST 3
SMITH NORTH 3
SMITH SOUTH 1
SMITH NORTH 3
SMITH SOUTH 1
D. REP AREA COUNT
JONES EAST 100
JONES NORTH 600
JONES WEST 500
SMITH NORTH 800
SMITH SOUTH 200
正解：A,C

質問 6：

ONE TWO
# Variable Type Len Pos # Variable Type Len Pos
2 sales Num 8 8 2 budget Num 8 8
1 year Num 8 0 3 sales Char 8 16
1 year Num 8 0

data three;
merge one two;
by year;
run;

A. Option A
B. Option C
C. Option D
D. Option B
正解：D