A00-211 Online Practice Questions and Answers

The following SAS program is submitted:

data one;

addressl = `214 London Way';

run;

data one;

set one;

address = tranwrd(address1, `Way', `Drive'); run;

What are the length and value of the variable ADDRESS?

A. Length is 14; value is `214 London Dri'.

B. Length is 14; value is `214 London Way'.

C. Length is 16; value is `214 London Drive'.

D. Length is 200; value is `214 London Drive'.

Given the raw data file YEARAMT:

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

1901 2

1905 1

1910 6

1925 .

1941 1

The following SAS program is submitted:

data coins;

infile `yearamt';

input year quantity;

run;

Which statement(s) completed the program and produced a non-missing value for the variable

TOTQUANTITY in the final observation of the output data set?

A. totquantity + quantity;

B. totquantity = sum(totquantity + quantity);

C. retain totquantity; totquantity = totquantity + quantity;

D. retain totquantity0; totquantity = totquantity + quantity;

The SAS data set named WORK.SALARY contains 10 observations for each department, and is currently ordered by Department. The following SAS program is submitted:

Which statement is true?

A. The by statement in the DATA step causes a syntax error.

B. The statement Payroll+(MonthlyWageRate*12); in the data step causes a syntax error.

C. The values of the variable Payroll represent the monthly total for each department in the WORK.SALARY data set.

D. The values of the variable Payroll represent a monthly total for all values of WAGERATE in the WORK.SALARY data set.

Given the raw data record in the file phone.txt:

Which SAS statement completes the program and results in a value of "James Stevens" for the variableFullName?

A. FullName=CATX(' ',EmpFName,EmpLName);

B. FullName=CAT(' ',EmpFName,EmpLName);

C. FullName=EmpFName!!EmpLName;

D. FullName=EmpFName + EmpLName;

Given the data set WORK.EMPDATA:

Which one of the following where statements would display observations with job titles containing the word 'Manager'?

A. where substr(Job_Title,(length(Job_Title)-6))='Manager';

B. where upcase(scan(Job_Title,-1,' '))='MANAGER';

C. where Job_Title='% Manager ';

D. where Job_Title like '%Manager%';

Which statement is true concerning the SAS automatic variable _ERROR_?

A. It cannot be used in an if/then condition.

B. It cannot be used in an assignment statement.

C. It can be put into a keep statement or keep= option.

D. It is automatically dropped.

The following SAS DATA step is submitted:

data work.accounting; set work.department; length jobcode $ 12; run;

The WORK.DEPARTMENT SAS data set contains a character variable named JOBCODE with a length of

5.

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

A. 5

B. 8

C. 12

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

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 CALENDAR are listed below:

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

01012000

The following SAS program is submitted:

data test;

infile 'calendar';

input @1 date mmddyy10.;

if date = '01012000'd then event = 'January 1st';

run;

Which one of the following is the value of the EVENT variable?

A. 01012000

B. January 1st

C. . (missing numeric value)

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

FILL BLANK

Given the SAS data set WORK.EMP_NAME:

Given the SAS data set WORK.EMP_DEPT:

The following program is submitted:

How many observations are in data set WORK.ALL after submitting the program?

A. 2