A00-201 Online Practice Questions and Answers

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. 2000

B. `2000'

C. (missing numeric value)

D. ` `(missing character value)

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

capacity airplanetype staff 150 Large 10

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

A. data work.test capacity = 150; 1100 le capacity le 200 then airplanetype = `Large' and staff = 10; else airplanetype = `Small' and staff = 5; run;

B. 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;

C. 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;

D. data work.test;D.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;

Which one of the following is true of the SUM statement in a SAS DATA step program?

A. It is only valid in conjunction with a SUM function.

B. It is not valid with the SET, MERGE and UPDATE statements.

C. It adds the value of an expression to an accumulator variable and ignores missing values.

D. It does not retain the accumulator variable value from one iteration of the SAS DATA step to the next.

The following SAS program is submitted:

data work.pieces; do while (n It 6); n + 1; end; run;

Which one of the following is the value of the variable N in the output data set?

A. 4

B. 5

C. 6

D. 7

Which one of the following statements is true regarding the SAS automatic _ERROR_ variable?

A. The _ERROR_ variable contains the values `ON' or `OFF'.

B. The _ERROR_ variable contains the values `TRUE' or `FALSE'.

C. The _ERROR_ variable is automatically stored in the resulting SAS data set.

D. The _ERROR_ variable can be used in expressions or calculations in the DATA step.

The following SAS program is submitted:

proc contents data = sasuser.airplanes; run;

Which one of the following is produced as output?

A. the data portion of every data set in the SASUSER library

B. the data portion of the data set SASUSER.AIRPLANES only

C. the descriptor portion of every data set in the SASUSER library

D. the descriptor portion of the data set SASUSER AIRPLANES only

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. 110

C. 200

D. (missing numeric value)

The following SAS program is submitted:

data_null_;

set old;

put sales 1 sales2;

run;

Where is the output written?

A. the SAS log

B. the raw data file that was opened last

C. the SAS output window or an output file

D. the data set mentioned in the DATA statement

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. 400 for PROC PRINT 4500 for PROC MEANS

B. 401 for PROC PRINT 4501 for PROC MEANS

C. 401 for PROC PRINT 4500 for PROC MEANS

D. 500 for PROC PRINT 5000 for PROC MEANS

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 JOSCATEGORY in the output data set?

A. FA

B. FA1

C. FA1

D. ``(missing character value)