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

The following program is submitted:

proc contents data=_all_;

run;

Which statement best describes the output from the submitted program?

A.

The output contains only a list of the SAS data sets that are contained in the WORK library.

B.

The output displays only the contents of the SAS data sets that are contained in the WORK library.

C.

The output displays only the variables in the SAS data sets that are contained in the WORK library.

D.

The output contains a list of the SAS data sets that are contained in the WORK library and displays the contents of those data sets.

Full Access
Question # 34

The following SAS DATA step executes on Monday, April 25, 2000:

data newstaff;

set staff;

start_date = today();

run;

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

A.

a character string with the value '04/25/2000'

B.

a character string with the value 'Monday, April 25, 2000'

C.

the numeric value 14725, representing the SAS date for April 25, 2000

D.

the numeric value 04252000, representing the SAS date for April 25, 2000

Full Access
Question # 35

The following SAS program is submitted:

What is the result?

A.

The value of the variable Discount in the output data set is 2000. No messages are written to the SAS log.

B.

The value of the variable Discount in the output data set is 2000. A note that conversion has taken place is written to the SAS log.

C.

The value of the variable Discount in the output data set is missing. A note in the SAS log refers to invalid numeric data.

D.

The variable Discount in the output data set is set to zero. No messages are written to the SAS log.

Full Access
Question # 36

There are 451 observations in the data set WORK.STAFF. The following SAS program is submitted:

What will be the value of NewVar when SAS writes the last observation?

A.

451

B.

1

C.

0

D.

. (a missing value)

Full Access
Question # 37

The following SAS program is submitted:

proc means data = sasuser.houses std mean max;

var sqfeet;

run;

Which one of the following is needed to display the standard deviation with only two decimal places?

A.

Add the option MAXDEC = 2 to the MEANS procedure statement.

B.

Add the statement MAXDEC = 7.2; in the MEANS procedure step.

C.

Add the statement FORMAT STD 7.2; in the MEANS procedure step.

D.

Add the option FORMAT = 7.2 option to the MEANS procedure statement.

Full Access
Question # 38

This question will ask you to provide a missing option. Given the following SAS program:

Which option needs to be added to wrap the labels to the next line whenever it encounters an asterisk?

A.

label = ‘*’

B.

labelsplit = ‘*’

C.

split = ‘*’

D.

wrap = ‘*’

Full Access
Question # 39

Given the following SAS data set WORK.EMPDATA:

Which WERE statement would display observations wit Job_Title containing the word “Manager”?

A.

where upcase(scan(Job_Title,-1,’ ‘))=’MANAGER’;

B.

where Job_Title like ‘Manager%’;

C.

where substr(Job_Title, (length(Job_Title)-6))=’Manager’;

D.

where Job_Title=’% Manager ‘;

Full Access
Question # 40

The following SAS program is submitted:

data work.total;

set work.salary(keep = department wagerate);

by department;

if first.department

then payroll = 0;

payroll + wagerate;

if last.department

run;

The SAS data set WORK.SALARY, currently ordered by DEPARTMENT, contains 100 observations for each of 5 departments.

What is the result?

A.

The WORK.TOTAL data set contains 5 observations.

B.

The WORKTDTAL data set contains 100 observations.

C.

The WORKTOTAL data set contains 500 observations.

D.

The program fails to execute due to errors.

Full Access
Go to page: