A00-211 Online Practice Questions and Answers

The following SAS program is submitted:

data work.empsalary;

set work.people (in = inemp)

work.money (in = insal);

if insal and inemp;

run;

The SAS data set WORKPEOPLE has 5 observations, and the data set WORKMONEY has 7

observations. How many observations will the data set WORK.EMPSALARY contain?

A. 0

B. 5

C. 7

D. 12

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.

Given the SAS data set PEPM.STUDENTS:

PERM.STUDENTS NAME AGE

--------- ------ Alfred 14

Alice13

Barbara13

Carol14

The following SAS program is submitted:

libname perm `SAS data library';

data students;

set perm.students;

file `file specification';

put name $15. @5 age 2.;

run;

What is written to the output raw data file?

A. ----I----10---I----20---I----30 Alfred 14 Alice 13

Barbara 13

Carol 14

B. ----I----10---I----20---I----30 Alfr14 Alic13 Barb13a Carol 4

C. ----I----10---I----20---I----30 Alfr14ed Alic130 Barb13ara Caro141

D. ----I----10---I----20---I----30 Alfred14 Alice13 Barbara13 Carol14

Which statement describes a characteristic of the SAS automatic variable _ERROR_?

A. The _ERROR_ variable maintains a count of the number of data errors in a DATA step.

B. The _ERROR_ variable is added to the program data vector and becomes part of the data set being created.

C. The _ERROR_ variable can be used in expressions in the DATA step.

D. The _ERROR_ variable contains the number of the observation that caused the data error.

Given the SAS data set WORK.ORDERS:

The variable order_id is numeric; customer is character; and shipped is numeric, contains a SAS date value, and is shown with the DATE9. format. A programmer would like to create a new variable, ship_note, that shows a character value with the order_id, shipped date, and customer name. For example, given the first observation ship_note would have the value "Order 9341 shipped on 02FEB2009 to Josh Martin".

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

A. ship_note=catx(' ','Order',order_id,'shipped on',input(shipped,date9.),'to',customer);

B. ship_note=catx(' ','Order',order_id,'shipped on',char(shipped,date9.),'to',customer);

C. ship_note=catx(' ','Order',order_id,'shipped on',transwrd(shipped,date9.),'to',customer);

D. ship_note=catx(' ','Order',order_id,'shipped on',put(shipped,date9.),'to',customer);

The following SAS program is submitted:

data work.clients;

calls = 6;

do while (calls le 6);

calls + 1;

end;

run;

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

A. 4

B. 5

C. 6

D. 7

A raw data record is listed below:

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

1999/10/25

The following SAS program is submitted:

data projectduration;

infile 'file-specification';

input date $ 1 - 10;

run;

Which one of the following statements completes the program above and computes the duration of the

project in days as of today's date?

A. duration = today( ) - put(date,ddmmyy10.);

B. duration = today( ) - put(date,yymmdd10.);

C. duration = today( ) - input(date,ddmmyy10.);

D. duration = today( ) - input(date,yymmdd10.);

The following SAS program is submitted:

data work.test;

array agents{4} $ 12 sales1 - sales4;

run;

Which one of the following represents the variables that are contained in the output data set?

A. SALES1, SALES2, SALES3, SALES4

B. AGENTS1, AGENTS2, AGENTS3, AGENTS4

C. None, the DATA step fails because the ARRAY statement can reference only numeric data.

D. None, the DATA step fails because the ARRAY statement can reference only pre-existing variables.

The following SAS program is submitted:

data revenue; set year_1; var1 = mdy(1,15,1960); run;

Which one of the following values does the variable named VAR1 contain?

A. 14

B. 15

C. 1151960

D. '1/15/1960'

The following SAS program is submitted:

data work.totalsales (keep = monthsales{12} );

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

array monthsales {12} ;

do i=1 to 12;

monthsales{i} = sales;

end;

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 executes with warnings and creates the WORK.TOTALSALES data set.

D. The program executes without errors or warnings and creates the WORK.TOTALSALES data set