A00-211 Online Practice Questions and Answers

The following SAS program is submitted:

How many observations are written to the WORK.SALES data set?

A. 0

B. 1

C. 5

D. 60

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

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

24613 $25.31

The following SAS program is submitted:

data inventory;

infile 'product';

input idnum 5. @10 price;

run;

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

A. 25.31

B. $25.31

C. . (missing numeric value)

D. No value is stored as the program fails to execute due to errors.

The following SAS program is submitted:

data test;

set sasuser.employees;

if 2 le years_service le 10 then

amount = 1000;

else amount = 0;

amount_per_year = years_service / amount

run;

What is the value of the variable AMOUNT_PER_YEAR if an employee has been with the company for

one year?

A. 0

B. 0.001

C. 1

D. . (missing numeric value)

Which statement specifies that records 1 through 10 are to be read from the raw data file customer.txt?

A. infile 'customer.txt' 1-10;

B. input 'customer.txt' stop@10;

C. infile 'customer.txt' obs=10;

D. input 'customer.txt' stop=10;

Given the SAS data set WORK.TEMPS:

The following program is submitted:

Which output is correct?

A. Option A

B. Option B

C. Option C

D. Option D

The following SAS program is submitted:

What is produced as output?

A. A file named test.cvs that can only be opened in Excel.

B. A text file named test.cvs that can be opened in Excel or in any text editor.

C. A text file named test.cvs that can only be opened in a text editor.

D. A file named test.cvs that can only be opened by SAS.

The following SAS program is submitted:

What will the data set WORK.TEST contain?

A. Option A

B. Option B

C. Option C

D. Option D

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

Which one of the following SAS procedures displays the data portion of a SAS data set?

A. PRINT

B. FSLIST

C. CONTENTS

D. DATASETS

The following SAS program is submitted:

data work.totalsales;

set work.monthlysales(keep = year product sales);

retain monthsales {12} ;

array monthsales {12} ;

do i = 1 to 12;

monthsales{i} = sales;

end;

cnt + 1;

monthsales{cnt} = sales;

run;

The data set named WORK.MONTHLYSALES has one observation per month for each of five years for a

total of 60 observations.

Which one of the following is the result of the above program?

A. The program fails execution due to data errors.

B. The program fails execution due to syntax errors.

C. The program runs with warnings and creates the WORK.TOTALSALES data set with 60 observations.

D. The program runs without errors or warnings and creates the WORK.TOTALSALES data set with 60 observations

The following SAS program is submitted: How many raw data records are read during each iteration of the DATA step?

A. 1

B. 2

C. 3

D. 4

Given the SAS data set WORK.ORDERS:

The variable Order_id is numeric; Customer is character; and Ship_date is a numeric containing a SAS

date value.

A programmer would like to create a new variable called Note, that shows a character value with the

Order_id and Ship_date shown with a date9. format. For the first observation, Note would look like the

following: "Order 9341 shipped on 02FEB2009".

Which of the following statement will correctly create the value and assign it to Note?

A. note=catx(' ','Order',order_id,'shipped on',input(ship_date,date9.));

B. note=catx(' ','Order',order_id,'shipped on',char(ship_date,date9.));

C. note=catx(' ','Order',order_id,'shipped on',transwrd(ship_date,date9.));

D. note=catx(' ','Order',order_id,'shipped on',put(ship_date,date9.));

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

The following SAS program is submitted:

What is output?

A. Option A

B. Option B

C. Option C

D. Option D

Given the SAS data set WORK.TEMPS with numeric variables Day and Temp and character variable Month:

The following SAS program is submitted:

proc sort data=WORK.TEMPS; by Day descending Month; run;

proc print data=WORK.TEMPS; run;

Which output is correct?

A. B. C. D.