SASInstitute SAS base programming 認定 A00-201 試験問題:
1. The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below:
The following SAS program is submitted:
data work.empdata;
merge work.employee
work.salary;
by fname;
totsal + salary;
run;
How many variables are output to the WORK.EMPDATA data set?
A) 4
B) 5
C) No variables are output to the data set as the program fails to execute due to errors.
D) 3
2. The following SAS program is submitted:
data work.test;
Author = 'Christie, Agatha';
First = substr(scan(author,2,' ,'),1,1);
run;
Which one of the following is the value of the variable FIRST in the output data set?
A) A
B) ' ' (missing character value)
C) C
D) Agatha
3. When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
A) 500 for PROC PRINT
5000 for PROC MEANS
B) 401 for PROC PRINT
4 501 for PROC MEANS
C) 401 for PROC PRINT
4 500 for PROC MEANS
D) 400 for PROC PRINT
4 500 for PROC MEANS
4. When the following SAS program is submitted, the data set SASDATA.PRDSALES contains 5000 observations:
libname sasdata 'SAS-data-library';
options obs = 500;
proc print data = sasdata.prdsales (firstobs = 100);
run;
options obs = max;
proc means data = sasdata.prdsales (firstobs = 500);
run;
How many observations are processed by each procedure?
A) 500 for PROC PRINT
5 000 for PROC MEANS
B) 401 for PROC PRINT
4 501 for PROC MEANS
C) 401 for PROC PRINT
4 500 for PROC MEANS
D) 400 for PROC PRINT
4500 for PROC MEANS
5. The SAS data set named COMPANY.PRICES is listed below:
The following SAS program is submitted:
libname company 'SAS-data-library';
data hware inter soft;
set company.prices (keep = producttype price);
if price le 5.00;
if producttype = 'HARDWARE' then output HWARE;
else if producttype = 'NETWORK' then output INTER;
else if producttype = 'SOFTWARE' then output SOFT;
run;
How many observations does the HWARE data set contain?
A) 4
B) 6
C) 2
D) 0
質問と回答:
質問 # 1 正解: A | 質問 # 2 正解: A | 質問 # 3 正解: B | 質問 # 4 正解: B | 質問 # 5 正解: C |