Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

Note! Following A00-211 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

A00-211 Exam Dumps - SAS Base Programming for SAS (r) 9

Go to page:
Question # 25

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.

1

B.

2

C.

3

D.

5

Full Access
Question # 26

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

WORK.ONE

Num Char

------ ------

1 23

3 23

1 77

The following SAS program is submitted:

proc print data=WORK.ONE;

where Num='1';

run;

What is output?

A.

Num Char--- ----1 23

B.

Num Char--- ----1 231 77

C.

Num Char--- ----1 233 231 77

D.

No output is generated.

Full Access
Question # 27

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.

Full Access
Question # 28

The following SAS program is submitted:

data test;

infile ‘file specification’;

input name $ amount@@;

run;

Which of the following is true?

A.

Two @@ together are the same as one c.

B.

Two @@ hold the data records until the bottom of the DATA step.

C.

Two @@ hold the raw data record across iterations of the DATA step.

D.

Two @@ are invalid syntax and will cause the program to fail to execute.

Full Access
Question # 29

What describes the SAS automatic _ERROR_ variable?

A.

The _ERROR_ variable contains the values ‘TRUE’ or ‘FALSE.’

B.

The _ERROR variable maintains a count of the number of data errors.

C.

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

D.

The ERROR_variable contains the number or the observation that caused the error.

Full Access
Question # 30

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.

Full Access
Question # 31

The following SAS program is submitted:

data work.passengers;

if OrigPassengers = . then'

OrigPassengers = 100;

TransPassengers = 100;

OrigPassengers = .;

TotalPassengers = sum (OrigPassengers, TransPassengers) +0;

run;

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

A.

0

B.

100

C.

200

D.

(missing numeric value)

Full Access
Question # 32

Given the contents of the raw data file TYPECOLOR.DAT:

The following SAS program is submitted:

What are the values of the variables Type and Color?

A.

Type=daisy, Color=yellow

B.

Type=daisy, Color=w

C.

Type=daisy, Color=daisyyellow

D.

Type=daisy, Color=

Full Access
Go to page: