Official Bank 0/270

SAS Base Programming for SAS (r) 9 Exam (A00-211) - SASI Actual Exam Questions

Last updated on May 01, 2026

97% Exam Compliance
270 Total Questions
1
Question

The SAS data sets WORK.EMPLOYEE and WORK.SALARY are listed below: WORK.EMPLOYEE WORK.SALARY fname age fname salary Bruce 30 Bruce 25000 Dan 40 Bruce 35000 Dan 25000 The following SAS program is submitted: data work.empdata; merge work.employee work.salary; by fname; totsal + salary; run; How many variables are output to the WORK.EMPDATA data set?

Options
A

3

B

4

C

5

D

No variables are output to the data set as the program fails to execute due to errors

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question

Given the raw data file ‘DEPENDENTS.TXT’: The following SAS program is submitted: What will be the value of _ERROR_ in the Program Data Vector for each iteration of the DATA step?

Question image Question image
Options
A

Option

B

Option

C

Option

D

Option

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question

The following SAS program is submitted: What is the value of the variable Diff?

Question image
Options
A

1

B

0

C

-99

D

-1

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question

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?

Options
A

0

B

100

C

200

D

(missing numeric value)

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question

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?

Options
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’.

Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.