A00-211 Online Practice Questions and Answers

The value 110700 is stored in a numeric variable named SALARY.

Which FORMAT statement displays the value as $110,700.00 in a report?

A. format salary comma11.2;

B. format salary dollar8.2;

C. format salary dollar11.2;

D. format salary comma8.2 dollar8.2;

The following SAS program is submitted:

data WORK.DATE_INFO;

Day="01" ;

Yr=1960 ;

X=mdy(Day,01,Yr) ;

run;

What is the value of the variable X?

A. the numeric value 0

B. the character value "01011960"

C. a missing value due to syntax errors

D. the step will not compile because of the character argument in the mdy function.

The following SAS program is submitted:

options pageno = 1;

proc print data = sasuser.houses;

run;

proc means data = sasuser.shoes;

run;

The report created by the PRINT procedure step generates 5 pages of output.

What is the page number on the first page of the report generated by the MEANS procedure step?

B. 2

C. 5

D. 6

The following SAS program is submitted:

data work.products;

Product_Number = 5461;

Item = '1001';

Item_Reference = Item'/'Product_Number;

run;

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

A. 1001/5461

B. 1001/ 5461

C. . (missing numeric value)

D. The value can not be determined as the program fails to execute due to errors.

The following SAS program is submitted:

libname sasdata 'SAS-data-library';

data test;

set sasdata.chemists (keep = job_code);

if job_code = 'chem3'

then description = 'Senior Chemist';

run;

The variable JOB_CODE is a character variable with a length of 6 bytes.

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

A. 6 bytes

B. 8 bytes

C. 14 bytes

D. 200 bytes

The following SAS program is submitted:

data work.one;

x = 3;

y = 2;

z = x ** y;

run;

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

A. 6

B. 9

C. . (missing numeric value)

D. The program fails to execute due to errors.

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 DATA step is submitted:

libname temp 'SAS-data-library';

data temp.report;

set sasuser.houses;

newvar = price * 1.04;

run;

Which one of the following statements is true regarding the program above?

A. The program is reading from a temporary data set and writing to a temporary data set.

B. The program is reading from a temporary data set and writing to a permanent data set.

C. The program is reading from a permanent data set and writing to a temporary data set.

D. The program is reading from a permanent data set and writing to a permanent data set.

The following program is submitted:

proc contents data=_all_;

Which statement best describes the output from the submitted program?

A. The output displays only a list of the SAS data sets that are contained in the WORK library.

B. The output displays only the contents of the SAS data sets that are contained in the WORK library.

C. The output displays only the variables in the SAS data sets that are contained in the WORK library.

D. The output displays a list of the SAS data sets that are contained in the WORK library and displays their contents.

The following SAS program is submitted:

data WORK.PRODUCTS;

Prod=1;

do while (Prod LE 7);

Prod + 1;

end;

run;

What is the value of the variable Prod in the output data set?

A. 7

B. 8

C. 6

D. .(missing numeric)