The SAS data set ONE consists of five million observations and has 25 variables.
Which one of the following SAS programs successfully creates three new variables TOTREV, TOTCOST, and PROFIT and requires the least CPU time to be processed?

• A. data two;
  set one;
  totrev = sum(price * quantity);
  if totrev > 1000;
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;
• B. data two;
  set one;
  totrev = sum(price * quantity);
  where totrev > 1000;
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;
• C. data two;
  set one;
  where totrev > 1000;
  totrev = sum(price * quantity);
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;
• D. data two;
  set one;
  totrev = sum(price * quantity);
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  if totrev > 1000;
  run;

Given the following SAS data sets ONE and TWO:
ONE TWO NUM COUNTRY NUM CITY
1 CANADA 3 BERLIN 2 FRANCE 5 TOKYO 3 GERMANY 4 BELGIUM 5 JAPAN
The following SAS program is submitted:
proc sql;
select country
from one
where not exists
(select *
from two
where one.num = two.num); quit;
Which one of the following reports is generated?

• A. COUNTRY
  FRANCE BELGIUM
• B. COUNTRY
  CANADA FRANCE GERMANY
• C. COUNTRY
  GERMANY JAPAN
• D. COUNTRY
  CANADA FRANCE BELGIUM

The following SAS program is submitted:
%let var = chicago, 1;
data a;
var = 'new york, 2';
newvar = %scan(&var,2,%str());
run;
Which one of the following explains why the program fails to execute?

• A. The %SCAN function does not exist.
• B. The %STR() is invalid syntax.
• C. The macro variable VAR does not get created properly.
• D. The %SCAN function has too many arguments.

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?

• A. data new;
  set temp;
  if a = 6 then
  b = 'Large ';
  else if a in (1, 2) then
  b = 'Medium';
  else if a = 8 then
  b = 'Small';
• B. data new;
  set temp;
  if a = 8 then
  b = 'Small ';
  else if a in(1, 2) then
  b = 'Medium';
  else if a = 6 then
  b = 'Large';
  run;
• C. data new;
  set temp;
  if a = 6 then
  b = 'Large ';
  if a in (1, 2) then
  b = 'Small';
  run;
• D. data new;
  set temp;
  if a in (1, 2) then
  b = 'Medium';
  else if a = 8 then
  b = 'Small';
  else if a = 6 then
  b = 'Large';
  run;

Which one of the following techniques concatenates data in SAS?

• A. the APPEND procedure
• B. the DATA step with a MERGE statement
• C. the INTERSECT operator in the SQL procedure
• D. the DATA step with a COMBINE statement