A00-201 Online Practice Questions and Answers

A raw data record is listed below:

----|----10----|----20----|----30

Printing 750

The following SAS program is submitted:

data bonus;

infile `file-specification';

input dept $ 1-11 number 13-15;

run;

Which one of the following SAS statements completes the program and results in a value of `Printing 750' for the DEPARTMENT variable?

A. department = trim(dept) II number;

B. department = dept II input(number,3.);

C. department = trim(dept) II put(number,3.);

D. department = input(dept,11.) II input(number,3.);

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

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 SAS data set BANKS is listed below:

The following SAS program is submitted:

data newbank;

do year = 1 to 3;

set banks;

capital + 5000;

end;

run;

Which one of the following represents how many observations and variables will exist in the SAS data set NEWBANK?

A. 0 observations and 0 variables

B. 1 observations and 4 variables

C. 3 observations and 3 variables

D. 9 observations and 2 variables

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

B. 110

C. 200

D. (missing numeric value)

A raw data file is listed below:

1901 2 1905 1 1910 6 1925 . 1941 1

The following SAS program is submitted and references the raw data file above:

data coins; infile `file-specification'; input year quantity; run;

Which one of the following completes the program and produces a non-missing value for the variable TOTQUANTITY in the last observation of the output data set?

A. totquantity + quantity;

B. totquantity = sum(totquantity + quantity);

C. totquantity 0; sum totquantity;

D. retain totquantity 0; totquantity = totquantity + quantity;

The following SAS program is submitted:

data revenue; set year_1; var1 = mdy(1,15,i960); run;

Which one of the following values does the variable named VAR1 contain?

A. 14

B. 15

C. 1151960

D. `1/15/1960'

On which portion(s) of a SAS data set does the PRINT procedure report?

A. the data portion only

B. the descriptor portion only

C. the descriptor portion and the data portion

D. neither the data portion nor the descriptor portion

The following SAS DATA step is submitted:

data sasdata.atlanta

sasdata.boston

work.portland work.phoenix;

set company.prdsales;

if region = `NE' then output boston;

if region = `SE' then output atlanta;

if region = `SW' then output phoenix;

if region = `NW' then output portland;

run;

Which one of the following is true regarding the output data sets?

A. No library references are required.

B. The data sets listed on all the IF statements require a library reference.

C. The data sets listed in the last two IF statements require a library reference.

D. The data sets listed in the first two IF statements require a library reference.

The following SAS program is submitted:

data work.test;

Author = `Agatha Christie';

First = substr(scan(author,1,' ,`)1 ,1);

run;

Which one of the following is the length of the variable FIRST in the output data set?

A. 1

B. 6

C. 15

D. 200