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

The following SAS program is submitted:
data work.january;
set work.allmonths (keep = product month num_sold cost);
if month = 'Jan' then output work.january;
sales = cost * num_sold;
keep = product sales;
run;
Which variables does the WORK.JANUARY data set contain?

• A.PRODUCT, SALES, MONTH, NUM_SOLD and COST only
• B.PRODUCT, MONTH, NUM_SOLD and COST only
• C.PRODUCT and SALES only
• D.An incomplete output data set is created due to syntax errors.

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.100
• B.200
• C.110
• D.. (missing numeric value)

The following SAS program is submitted:
data work.flights;
destination = 'cph';
select(destination);
when('LHR') city = 'London';
when('CPH') city = 'Copenhagen';
otherwise city = 'Other';
end;
run;
Which one of the following is the value of the CITY variable?

• A.' ' (missing character value)
• B.Copenhagen
• C.Copenh
• D.Other

The following SAS program is submitted:
proc means data = sasuser.houses std mean max;
var sqfeet; run;
Which one of the following is needed to display the standard deviation with only two decimal places?

• A.Add the statement MAXDEC = 7.2; in the MEANS procedure step.
• B.Add the option MAXDEC = 2 to the MEANS procedure statement.
• C.Add the statement FORMAT STD 7.2; in the MEANS procedure step.
• D.Add the option FORMAT = 7.2 option to the MEANS procedure statement.

The following SAS program is submitted: l
ibname company 'SAS-data-library';
proc sort data = company.payroll;
by EmployeeIDNumber;
run;
Write access has been granted to the COMPANY library.
Which one of the following represents how the observations are sorted?

• A.COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.
• B.COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
• C.COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.
• D.COMPANY.PAYROLL is stored in original order, and a new data set
  COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.