A00-201 Online Practice Questions and Answers

The following SAS program is submitted;

data work.month; date = put('13mar2000'd,ddmmw10.); run;

Which one of the following represents the type and length of the variable DATE in the output data set?

A. numeric, 8 bytes

B. numeric, 10bytes

C. character, 8 bytes

D. character, 10 bytes

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;

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_null;

set old (keep = prod sales 1 sales2);

file `file-specification';

put sales1 sales2; run;

Which one of the following default delimiters separates the fields in the raw data file created?

A. : (colon)

B. (space)

C. , (comma)

D. ; (semicolon)

Which one of the following ODS statement options terminates output being written to an HTML file?

A. END

B. QUIT

C. STOP

D. CLOSE

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 and SALES only

B. PRODUCT, MONTH, NUM_SOLD and COST only

C. PRODUCT, SALES, MONTH, NUM_SOLD and COST only

D. An incomplete output data set is created due to syntax errors.

The following SAS program is submitted:

data work.month; d ate = input('13mar2000',date9.); run;

Which one of the following represents the type and length of the variable DATE in the output data set?

A. numeric, 8 bytes

B. numeric, 9 bytes

C. character, 8 bytes

D. character, 9 bytes

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

In the following SAS program, the input data files are sorted by the NAMES variable:

libname temp SAS-data-library';

data temp.sales;

merge temp.sales

work.receipt;

by names;

run;

Which one of the following results occurs when this program is submitted?

A. The program executes successfully and a temporary SAS data set is created.

B. The program executes successfully and a permanent SAS data set is created.

C. The program fails execution because the same SAS data set is referenced for both read and write operations.

D. The program fails execution because the SAS data sets on the MERGE statement are in two different libraries.

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.