A00-211 Online Practice Questions and Answers

The following SAS program is submitted:

Data_null_;

set old;

put sales 1 sales2;

run;

Where is the output written?

A. to the SAS log

B. to the SAS data set _NULL_

C. to the SAS output window or to an output file D. to the raw data file that was most recently opened

The SAS data set WORK.ONE contains a numeric variable named Num ana character variable named Char:

WORK.ONE Num Char

1 23 3 23 1 77 The following SAS program is submitted: proc print data=WORK.ONE;

where Num='1'; run;

What is output?

A. Num Char 1 23

B. Num Char

1 23

1 77

C. Num Char

1 23

3 23

1 77

D. No output is generated.

The following SAS program is submitted:

data WORK.DATE_INFO; X="01Jan1960" D;

run;

What variable X contains what value?

A. the numeric value 0

B. the character value "01Jan1960"

C. the date value 01011960

D. the code contains a syntax error and does not execute.

Consider the following data step:

The computed variables City and State have their values assigned using two different methods, a RETAIN

statement and an Assignment statement.

Which statement regarding this program is true?

A. The RETAIN statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

B. Both the RETAIN and assignment statement are being used to initialize new variables and are equally efficient. Method used is a matter of programmer preference.

C. The assignment statement is fine, but the value of City will be truncated to 8 bytes as the LENGTH statement has been omitted.

D. City's value will be assigned one time, State's value 5 times.

The following SAS program is submitted:

libname sasdata 'SAS-data-library';

data test;

set sasdata.chemists;

if jobcode = 'chem3'

then description = 'Senior Chemist';

else description = 'Unknown';

run;

A value for the variable JOBCODE is listed below:

JOBCODE

CHEM3

Which one of the following values does the variable DESCRIPTION contain?

A. chem3

B. Unknown

C. Senior Chemist

D. ' ' (missing character value)

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

The SAS data set WORK.AWARDS is listed below:

fname points

Amy 2

Amy 1

Gerard 3

Wang 3

Wang 1

Wang 2

The following SAS program is submitted:

proc sort data = work.awards;

by descending fname points;

run;

Which one of the following represents how the observations are sorted?

A. Wang 3 Gerard 3 Wang 2 Amy 2 Wang 1 Amy 1

B. Wang 3 Wang 2 Wang 1 Gerard 3 Amy 2 Amy 1

C. Wang 3 Wang 1 Wang 2 Gerard 3 Amy 2 Amy 1

D. Wang 1 Wang 2

Wang 3

Gerard 3

Amy 1

Amy 2

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

Given the SAS data set WORK.P2000:

And the SAS data set WORK.P2008:

The following output is desired:

Which SAS program correctly combines the data?

A. Option A

B. Option B

C. Option C

D. Option D

The following SAS program is submitted: How many observations are written to the WORK.VOLUME data set?

A. 1