A00-211 Online Practice Questions and Answers

The following SAS program is submitted:

data work.test; array items{3} _temporary_; run;

What are the names of the variable(s) in the WORKTEST data set?

A. ITEMS

B. ITEMS1, ITEMS2, ITEMS3

C. No variables are created because it is a temporary array.

D. The program fails to execute because there are no variables listed on the ARRAY statement.

The following code was modified to generate the results further below:

proc format; value agegrp low-12 ='Pre-Teen'

13-high = 'Teen';

run;

proc means data=SASHELP.CLASS;

var Height;

class Sex Age;

format Age agegrp.;

run;

The following results were generated to display only specific statistics and limit the decimals with the

modification: Which statement below was modified or added to generate the results above:

A. var Height / nobs min max mean maxdec=1;

B. proc means data=SASHELP.CLASS maxdec=1 ;

C. proc means data=SASHELP.CLASS min max mean maxdec=1;

D. output nobs min max mean maxdec=1;

Consider the following data step:

data WORK.NEW; set WORK.OLD;

Count+1; run;

The varaible Count is created using a sum statement. Which statement regarding this variable is true?

A. It is assigned a value 0 when the data step begins execution.

B. It is assigned a value of missing when the data step begins execution.

C. It is assigned a value 0 at compile time.

D. It is assigned a value of missing at compile time.

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 following SAS program is submitted:

libname company 'SAS-data-library';

proc sort data = company.payroll;

by EmployeeIDNumber;

run;

Write access has been granted to the COMPANY library.

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

A. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber.

B. COMPANY.PAYROLL is stored in original order, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber.

C. COMPANY.PAYROLL is stored in original order, and a new data set COMPANY.PAYROLLSORTED is created in sorted order by EmployeeIDNumber.

D. COMPANY.PAYROLL is recreated in sorted order by EmployeeIDNumber, and a new data set PAYROLL is created in sorted order by EmployeeIDNumber

The contents of the raw data file FURNITURE are listed below:

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

chair,,table

chair,couch,table

The following SAS program is submitted:

data stock;

infile 'furniture' dsd;

input item1 $ item2 $ item3 $;

run;

Which one of the following is the value of the variable named ITEM2 in the first observation of the output

data set?

A. table

B. ,table

C. . (missing numeric value)

D. ' ' (missing character value)

The following SAS program is submitted and reads 100 records from a raw data file:

data work.total;

infile 'file-specification' end = eof;

input name $ salary;

totsal + salary;

run;

Which one of the following IF statements writes the last observation to the output data set?

A. if end = 0;

B. if eof = 0;

C. if end = 1;

D. if eof = 1;

The following SAS program is submitted:

proc print data = sasuser.houses; run;

proc means data = sasuser.shoes; run; Which one of the following OPTIONS statements resets the page number to 1 for the second report?

A. options pageno = 1;

B. options pagenum = 1;

C. options reset pageno = 1;

D. options reset pagenum = 1;

This question will ask you to provide lines of missing code.

The following SAS program is submitted:

Which statement inserted, respectively, in the two locations indicated above create a report stored in a PDF file?

A. B. C. D.

Given the following SAS log entry:

What caused the error?

A. The INPUT statement should be after the DATALINES statement.

B. The CANCEL option is required with DATALINES.

C. A semi-colon is missing on the DATALINES statement.

D. Character data must be specified in quotes.