A00-202 무료 덤프문제 온라인 액세스

Assume today is Tuesday, July 23, 2002. Which one of the following statements submitted at the beginning of a SAS session assigns the value Tuesday, July 23, 2002 to the macro variable START?

• A.%let start = %sysfunc(%today(),weekdate.);
• B.%let start = today(),format=weekdate.;
• C.%let start = %sysfunc(today(),weekdate.);
• D.%let start = today(),weekdate.;

Given the following SAS data set named WORK.INTERNAT:
WORK.INTERNAT LOCATION SUM
USA 30 EUR 40
The following SAS program is submitted:
%let LOC = Usa;
proc sql;
select *
from internat
where location = "&Loc"; quit;
Which one of the following is the result when the above code is executed on the above data set?

• A.No report is generated as the case of the compared values is different.
• B.A report is generated with the two original observations as the where clause does not work.
• C.No report is generated as the case of the macro variable name is different.
• D.A report is generated with one destination.

Given the following SAS data set ONE:
ONE JOB LEVEL SALARY
ACC 2 300 SEC 1 100 SEC 2 200 MGR 3 700 ACC 1 .
ACC 3 .
MGR 2 400
The following SAS data set TWO is created:
TWO
JOB LEVEL BONUS
ACC 2 30
MGR 3 70
MGR 2 40
Which one of the following SAS programs creates data set TWO?

• A.proc sql;
  create table two as
  select job, level, salary * 0.1 as bonus
  from one
  where salary > 20;
  quit;
• B.proc sql;
  create table two as
  select job, level, salary * 0.1 as bonus
  from one
  where bonus > 20;
  quit;
• C.proc sql;
  create table two as
  select job, level, salary * 0.1 as bonus
  from one
  where calculated salary * 0.1 > 20;
  quit;
• D.proc sql;D.proc sql;
  create table two as
  select job, level, salary * 0.1 as bonus
  from one
  where calculated bonus > 20;
  quit;

Given the following SAS statement:
%let idcode = Prod567;
Which one of the following statements stores the value 567 in the macro variable CODENUM?

• A.%let codenum = substr(&idcode,length(&idcode)-2);
• B.%let codenum = %substr(&idcode,%length(&idcode)-2);
• C.%let codenum = %substr(&idcode,%length(&idcode)-3);
• D.%let codenum = substr(&idcode,length(&idcode)-3);

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);
  where totrev > 1000;
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;
• B.data two;
  set one;
  totrev = sum(price * quantity);
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  if totrev > 1000;
  run;
• C.data two;
  set one;
  totrev = sum(price * quantity);
  if totrev > 1000;
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;
• D.data two;
  set one;
  where totrev > 1000;
  totrev = sum(price * quantity);
  totcost = sum(fixed,variable);
  profit = sum(totrev,otcost);
  run;