A00-202 試験問題を無料オンラインアクセス

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 left join two on one.year = two.year;
quit;
Which one of the following reports is generated?

• A.YEAR QTR BUDGET SALES
  2001 3 500 300 2001 4 400 300 2002 1 700 600
• B.YEAR QTR BUDGET SALES 2001 3 500 .
• C.YEAR QTR BUDGET SALES
  2001 3 500 .
  2001 4 400 300 2002 1 700 600
• D.YEAR QTR BUDGET SALES
  2001 4 400 300 2002 1 700 600

Given the following SAS data sets ONE and TWO:
ONE TWO NUM CHAR1 NUM CHAR2
1 A1 2 X1 1 A2 2 X2 2 B1 3 Y 2 B2 5 V 4 D
The following SAS program is submitted creating the output table THREE:
proc sql;
create table three as
select one.num, char1, char2
from one, two
where one.num = two.num; quit;
THREE NUM CHAR1 CHAR2
2 B1 X1 2 B1 X2 2 B2 X1 2 B2 X2
Which one of the following DATA step programs creates an equivalent SAS data set THREE?

• A.data three;
  merge one two;
  by num;
  run;
• B.data three;D.data three;
  set one;
  do i = 1 to numobs;
  set two(rename = (num = num2)) point = i
  nobs = numobs;
  if num2 = num then output;
  end;
  drop num2;
  run;
• C.data three;
  set one;
  set two;
  by num;
  run;
• D.data three;C.data three;
  merge one (in = in1) two (in = in2);
  by num;
  if in1 and in2;
  run;

Given the following SAS data set ONE:
ONE DIVISION SALES
A 1234 A 3654 B 5678
The following SAS program is submitted:
data _null_; set one;
by division;
if first.division then
call symput('mfirst',sales);
if last.division then
call symput('mlast',sales);
run;
Which one of the following is the value of the macro variable MFIRST when the above program finishes execution?

• A.3654
• B.null
• C.5678
• D.1234

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.order by 1, 3 desc
• B.order by 1, 3
• C.order by product, desc revenue
• D.orderby product, revenue desc

Given the following SAS data set ONE:
ONE
CATEGORY AGE SALARY BONUS
M 28 200 .
M 25 100 10
F 18 100 50
F 25 200 10
The following SAS program is submitted:
proc sql;
create table two as
select category, salary + bonus as EARNINGS from one; quit;
Which one of the following represents the data values stored in the data set TWO?

• A.CATEGORY EARNINGS
  M . M 110 F 150 F 210
• B.CATEGORY SALARY BONUS EARNINGS
  M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210
• C.CATEGORY EARNINGS
  M 200 M 110 F 150 F 210
• D.CATEGORY SALARY BONUS EARNINGS
  M 200 . . M 100 10 110 M 200 . 200 M 100 10 110 F 100 50 150 F 200 10 210