SASInstitute SAS base programming 認定 A00-201 試験問題:

1. The SAS data sets WORK.EMPLOYEE and WORK.SALARY are shown below:

The following SAS program is submitted:
data work.empdata;
< insert MERGE statement here>
by fname;
totsal + salary;
run;
Which one of the following statements completes the merge of the two data sets by the
FNAME variable?

A) merge work.employee
work.salary (rename = (fname = name));
B) merge work.employee
work.salary (rename = (name = fname));
C) merge work.employee
work.salary (name = fname);
D) merge work.employee
work.salary (fname = name);

2. The SAS data set named WORK.TEST is listed below:

Which one of the following SAS programs created this data set?

A) data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
end;
else
do;
airplanetype = 'Small';
staff = 5;
end;
run;
B) data work.test;
capacity = 150;
if 100 le capacity le 200 then
do;
airplanetype = 'Large';
staff = 10;
else
do;
airplanetype = 'Small'; airplanetype = 'Small';
staff = 5;
end;
run;
C) data work.test;
capacity = 150;
if 100 le capacity le 200 then
airplanetype = 'Large' and staff = 10;
else airplanetype = 'Small' and staff = 5;
run;
D) data work.test;data work.test;
capacity = 150;
if 100 le capacity le 200 then;
airplanetype = 'Small'; airplanetype = 'Small';
staff = 5;
else;
airplanetype = 'Large'; airplanetype = 'Large';
staff = 10;
run;

3. The following SAS program is submitted:
< insert ODS statement here>
proc means data = sasuser.shoes;
where product in ('Sandal' , 'Slipper' , 'Boot');
run;
Which one of the following ODS statements completes the program and sends the report to an HTML file?

A) ods html file = 'sales.html';
B) ods file html = 'sales.html';
C) ods file = 'sales.html';
D) ods html = 'sales.html';

4. The following SAS program is submitted:
proc datasets lib = sasuser;
contents data = class varnum;
quit;
Which one of the following is the purpose of the VARNUM option?

A) to print the total number of variables
B) to print a list of the variables in alphabetic order
C) to print a list of the variables in the order they were created
D) to print a list of variable names

5. Click the Exhibit button to view two reports. Assume permanent variable labels have been assigned.
The following SAS program is submitted and produces the first report:
proc report data = sasuser.shoes nowd;
column region subsidiary sales;
define subsidiary / display;
define region / group;
define sales / sum;
run;
Which one of the following corrects the program above to produce the second report shown in the exhibit?

A) Define the variable SUBSIDIARY with a GROUP usage.
B) Define the variable SUBSIDIARY with an ORDER usage.
C) Define the variable SUBSIDIARY with an ACROSS usage.
D) Define the variable SUBSIDIARY with a SUM usage.

質問と回答：