Online Access Free A00-211 Exam Questions

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.the numeric value 04252000, representing the SAS date for April 25, 2000
• C.a character string with the value 'Monday, April 25, 2000'
• D.the numeric value 14725, representing the SAS date for April 25, 2000

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 B
• B.Option D
• C.Option C
• D.Option A

The following SAS program is submitted:
proc format
value score 1 - 50 = 'Fail'
51 - 100 = 'Pass';
run;
proc report data = work.courses nowd;
column exam;
define exam / display format = score.;
run;
The variable EXAM has a value of 50.5.
How will the EXAM variable value be displayed in the REPORT procedure output?

• A.Fail
• B.50.5
• C.. (missing numeric value)
• D.Pass

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 231 77
• B.Num Char--- ----1 23
• C.Num Char--- ----1 233 231 77
• D.No output is generated.

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?

• A.3
• B.5
• C.4
• D.No variables are output to the data set as the program fails to execute due to errors