Free A00-212 Exam Braindumps
SAS Advanced Programming Exam for SAS 9 Questions 71–75 (page: 16)

Given the following SAS data sets ONE and TWO:

ONE TWO
YEAR QTR BUDGET YEAR QTR SALES
2001 3 500 2001 4 300
2001 4 400 2002 1 600
2002 1 700
The following SAS program is submitted:
proc sql;
select one.*, sales
from one, two;
quit;

Which one of the following reports is generated?

Given the following SAS data set ONE:
ONE
NUM VAR
1 A
2 B
3 C

Which one of the following SQL programs deletes the SAS data set ONE?

The SAS data set TEMP has the following distribution of values for variable A:

A Frequency
1 500,000
2 500,000
6 7,000,000
8 3,000

Which one of the following SAS programs requires the least CPU time to be processed?

The following SAS program is submitted:

%let value = 9;
%let value2 = 5;
%let newval = %eval(&value / &value2);

Which one of the following is the resulting value of the macro variable NEWVAL?

The following SAS program is submitted:

%let lib = %upcase(sasuser);
proc sql;
select nvar
from dictionary.tables
where libname = "&lib";
quit;

Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?