A00-201 무료 덤프문제 온라인 액세스

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 an ORDER usage.
• B.Define the variable SUBSIDIARY with a SUM usage.
• C.Define the variable SUBSIDIARY with an ACROSS usage.
• D.Define the variable SUBSIDIARY with a GROUP usage.

The following SAS program is submitted:
data work.staff;
JobCategory = 'FA';
JobLevel = '1';
JobCategory = JobCategory || JobLevel;
run;
Which one of the following is the value of the variable JOBCATEGORY in the output data set?

• A.FA 1
• B.' ' (missing character value)
• C.FA
• D.FA1

The following SAS program is submitted:
data work.retail;
cost = '20000';
total = .10 * cost;
run;
Which one of the following is the value of the variable TOTAL in the output data set?

• A.. (missing numeric value)
• B.' ' (missing character value)
• C.2000
• D.'2000'

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 (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 (rename = (fname = name));

The following SAS program is submitted:data work.passengers;
data work.passengers;
if OrigPassengers = . then
OrigPassengers = 100;
TransPassengers = 100;
OrigPassengers = .;
NonPaying = 10;
TotalPassengers = OrigPassengers + TransPassengers;
run;
Which one of the following is the value of the TOTALPASSENGERS variable in the output data set?

• A.. (missing numeric value)
• B.110
• C.200
• D.100