Free A00-212 Exam Braindumps (page: 9)

Page 8 of 47

The following SAS program is submitted:

options reuse=YES;
data sasuser RealEstate(compress=CHAR);
set sasuser houses;
run;

What is the effect of the REUSE=YES SAS system option?

  1. It tracks and recycles free space
  2. It allows a permanently stored SAS data set to be replaced
  3. It allows users to access the same SAS data set concurrently
  4. It allows updates in place

Answer(s): A



The SAS data set ONE contains fifty million observations and contains the variable
PRICE, QUANTITY, FIXED and VARIABLE. Which SAS program successfully creates three new variables TOTREV, TOTCOST and PROFIT and requires the least amount of CPU resources to be processed?

  1. data two;
    Set one;
    Where totrev>1000;
    Totrev=sum(price*quantity);
    Totcost=sum(fixed,variable);
    Profit=sum(totrev,-totcost);
    Run;
  2. data two;
    Set one;
    totrev=sum(price*quantity);
    where totrev>1000;
    totcost=sum(fixed,variable);
    profit=sum(totrev,-totcost);
    run;
  3. data two;
    Set one;
    Totrev=sum(price*quantity);
    If totrev>1000;
    Totcost=sum(fixed,variable);
    Profit=sum(totrev,-totcost);
    Run;
  4. data two;
    Set one;
    Totrev = sum(price*quantity);
    Totcost= sum(fixed,variable);
    If totrev>1000;
    Profit=sum(totrev,-totcost);
    Run;

Answer(s): C



The following SAS program is submitted:

data temp;
set sasuser.history(kep=date);
format date qtr
<insert BY statement here>
if first.date then total=0;
total+1;
if last.date;
run;
proc print data=temp;
run

SASUSER.HISTORY is sorted by the SAS date variable DATE.

The following output is required:
Date Total
1 13
3 15
4 25

Which By statement completes the data step and successfully generates the required output?

  1. by groupformat date;
  2. by formateed date;
  3. by notsorted date;
  4. by date qtr

Answer(s): A



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

  1. MODIFY and CHANGE statements
  2. RENAME statement only
  3. CHANGE statement only
  4. MODIFY and RENAME statements

Answer(s): C






Post your Comments and Discuss SAS Institute A00-212 exam with other Community members:

A00-212 Discussions & Posts