QUESTION: 101

The following SAS program is submitted:

options yearcutoff = 1950;
%macro y2kopt(date);
%if &date >= 14610 %then %do;
options yearcutoff = 2000;
%end;
%else %do;
options yearcutoff = 1900;
%end;
%mend;
data _null_ ;
date = "01jan2000"d;
call symput("date",left(date));
run;
%y2kopt(&date)

The SAS date for January 1, 2000 is 14610 and the SAS system option for
YEARCUTOFF is set to 1920 prior to submitting the above program.

Which one of the following is the value of YEARCUTOFF when the macro finishes execution?

1900
1920
1950
2000

Answer(s): D

Reveal Solution Next Question

QUESTION: 102

Which one of the following is the purpose of the REUSE= YES option in a compressed SAS data set?

It temporarily compresses observations in a SAS data set.
It allows users to update the same SAS data set concurrently.
It allows new observations to be inserted wherever enough free space exists.
It specifies that a new empty data set with a given name replaces an existing data set with the same name.

Answer(s): C

Reveal Solution Next Question

QUESTION: 103

Given the following SAS data set ONE:

ONE
LEVEL AGE
1 10
2 20
3 20
2 10
1 10
2 30
3 10
2 20
3 30
1 10

The following SAS program is submitted:
proc sql;
select level, max(age) as MAX
from one
group by level
having max(age) > (select avg(age) from one);
quit;

Which one of the following reports is generated?

LEVEL AGE
2 20
3 20
LEVEL AGE
2 30
3 30
LEVEL MAX
2 20
3 30
LEVEL MAX
2 30
3 30

Answer(s): D

Reveal Solution Next Question

QUESTION: 104

Which one of the following is true regarding the KEEP statement?

The KEEP statement is available in both the DATA and the PROC steps.
The KEEP statement selects the variables read from the input data set(s).
The KEEP statement applies to all data sets created within the same DATA step.
The KEEP statement applies only to the first data set created within the same DATA step if more than one data set is created.

Answer(s): C

Reveal Solution Next Question

Free A00-212 Exam Braindumps (page: 26)

QUESTION: 101

QUESTION: 102

QUESTION: 103

QUESTION: 104