Online Access Free A00-212 Practice Test

Given the data set SASHELP.CLASS:
SASHELP.CLASS
NAME AGE
Mary 15
Philip 16
Robert 12
Ronald 15
The following SAS program is submitted:
% let value = Philip;
proc print data = sashelp.class;
<insert WHERE statement here>
run;
Which WHERE statement successfully completes the program and procedures a report?

• A.Where upcase(name)=%upcase(&value);
• B.Where upcase(name)=upcase(&value);
• C.Where upcase(name)="%upcase(&value)";
• D.Where upcase(name)="upcase(&value)";

Which statement(s) in the DATASETS procedure alter(s) the name of a SAS data set stored in a SAS data library?

• A.RENAME statement only
• B.MODIFY and RENAME statements
• C.CHANGE statement only
• D.MODIFY and CHANGE statements

Given the following SAS program:
proc sql;
select product, type, sum(sales) as revenue
from one
group by product, type;
quit;
Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing
REVENUE?

• A.orderby product, revenue desc
• B.order by product, desc revenue
• C.order by 1, 3 desc
• D.order by 1, 3

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?

• A.1920
• B.2000
• C.1900
• D.1950

Given the following SAS data sets ONE and TWO:
ONE TWO
NUM CHAR1 NUM CHAR2
1 A 2 X
2 B 3 Y
4 D 5 V
The following SAS program is submitted creating the output table THREE:
data three;
set one two;
run;
THREE
NUM CHAR1 CHAR2
1 A
2 B
4 D
2 X
3 Y
5 V
Which one of the following SQL programs creates an equivalent SAS data set THREE?

• A.proc sql;
  create table three as
  select *
  from one
  union corr
  select *
  from two;
  quit;
• B.proc sql;
  create table three as
  select *
  from one
  outer union
  select *
  from two;
  quit;
• C.proc sql;
  create table three as
  select *
  from one
  outer union corr
  select *
  from two;
  quit;
• D.proc sql;
  create table three as
  select *
  from one
  outer union
  select *
  quit;