Online Access Free A00-201 Practice Test

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

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

CORRECT TEXT
The following SAS program is submitted:
data work.new;
length word $7;
amount = 7;
if amount = 5 then word = 'CAT';
else if amount = 7 then word = 'DOG';
else word = 'NONE!!!';
amount = 5;
run;
Which one of the following represents the values of the AMOUNT and WORD variables?

A raw data file is listed below:
----|----10---|----20---|----30
John McCloskey 35 71
June Rosesette 10 43
Tineke Jones 9 37
The following SAS program is submitted using the raw data file as input:
data work.homework;
infile 'file-specification';
input name $ age height;
if age LE 10;
run;
How many observations will the WORK.HOMEWORK data set contain?

• A.0
• B.3
• C.No data set is created as the program fails to execute due to errors.
• D.2

The following SAS SORT procedure step generates an output data set:
proc sort data = sasuser.houses out = report;
by style;
run;
In which library is the output data set stored?

• A.WORK
• B.HOUSES
• C.REPORT
• D.SASUSER

The following SAS program is submitted:
data work.total;
set work.salary(keep = department wagerate);
by department;
if first.department then payroll = 0;
payroll + wagerate;
if last.department;
run;
The SAS data set named WORK.SALARY contains 10 observations for each department, currently ordered by DEPARTMENT.
Which one of the following is true regarding the program above?

• A.The BY statement in the DATA step causes a syntax error.
• B.The values of the variable PAYROLL represent a total for all values of WAGERATE in the WORK.SALARY data set.
• C.FIRST.DEPARTMENT and LAST.DEPARTMENT are variables in the WORK.TOTAL data set.
• D.The values of the variable PAYROLL represent the total for each department in the
  WORK.SALARY data set.