SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 111:

  Which title statement would always display current date?

  A. title " Today is: and today.";
  B. title "Today is: sysfunc (today (), worddate)";
  C. title "Today is: and sysdate. ";
  D. title "Today is: andsysdate.";
  D. title "Today is: andsysdate.";

• Question 112:

  The following SAS program is submitted.

  filename sales ('external-file1' 'external-file2');

  data new;

  infile sales;

  input date date9. company $ revenue;

  run;

  Which one of the following is the result of including the FILENAME statement in this program?

  A. The FILENAME statement produces an ERROR message in the SAS log.
  B. The FILENAME statement associates SALES with external-file2 followed by external- file1.
  C. The FILENAME statement associates SALES with external-file1 followed by external- file2.
  D. The FILENAME statement reads record 1 from external-file 1, reads record 1 from external-file 2, and combines them into one record.
  C. The FILENAME statement associates SALES with external-file1 followed by external- file2.

• Question 113:

  The following SAS program is submitted:

  

  The purpose of FILEVAR = option on the INFILE statement is to name the variable next, whose value:

  A. Points to a new input file
  B. Points to an aggregate storage location
  C. Is output to the SAS data set WORK.NEW
  D. Is an input SAS data set reference
  D. Is an input SAS data set reference

• Question 114:

  Which one of the following options is available for SAS macro debugging?

  A. MLOGIC
  B. MDEBUG
  C. MSGLEVEL
  D. MAUTOSOURCE
  A. MLOGIC

• Question 115:

  The SAS data set ONE contains the variables X,Y,Z and W.

  The following SAS program is submitted:

  Proc transpose data =one

  Out=trans

  Name=new;

  By x;

  var y;

  run;

  What are the names of all of the columns created by the TRANSPOSE procedure?

  A. new, X,Y and _COL1_
  B. new, X and COL1 only
  C. new, Y and COL1 only
  D. new, X and Y only
  B. new, X and COL1 only

• Question 116:

  The following SAS program is submitted:

  Data sasuser.history;

  Set sasuser.history(keep=state x y

  Rename = (state=ST));

  Total=sum(x, y);

  Run;

  The SAS data set SASUSER.HISTORY has an index on the variable STATE.

  Which describes the result of submitting the SAS program?

  A. The index on STATE is deleted and an index on ST is created
  B. The index on STATE is recreated as an index on ST
  C. The index on STATE is deleted
  D. The index on STATE is updated as an index on ST
  C. The index on STATE is deleted

• Question 117:

  Given the non-indexed SAS data set TEMP: TEMP X Y

  P 52 P 45 A 13 A 56 R 34 R 12 R 78 The following SAS program is submitted: Proc print data=temp; A. X;
  B. By X groupd;
  C. By X notsorted;
  D. By descending X;

  C. By X notsorted;

• Question 118:

  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. null
  B. 1234
  C. 3654
  D. 5678
  D. 5678

• Question 119:

  The following SAS program is submitted:

  data new;

  do i=1,2,3

  nextfile=compress('March' || |);

  infile abc filevar=nextfile

  end=eof;

  do until (eof);

  input dept $sales;

  end;

  run;

  What is the purpose of the FILEVAR=option on the INFILE statement?

  A. It names the variable NEXTFILE, whose value is output to the SAS data set NEW
  B. It names the variable NEXTFILE, whose values point to an aggregate storage location
  C. It names the variable NEXTFILE, whose value is a SAS file reference
  D. It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file
  D. It names the variable NEXTFILE, whose change in value causes in INFILE statement to open a new input file

• Question 120:

  Given the following SAS data set ONE:

  ONE

  REP COST

  SMITH 200

  SMITH 400

  JONES 100

  SMITH 600

  JONES 100

  JONES 200

  JONES 400

  SMITH 800

  JONES 100

  JONES 300

  The following SAS program is submitted:

  proc sql;

  select rep, avg(cost) as AVERAGE

  from one

  group by rep

  having avg(cost) > (select avg(cost) from one);

  quit;

  Which one of the following reports is generated?

  A. REP AVERAGE JONES 200
  B. REP AVERAGE JONES 320
  C. REP AVERAGE SMITH 320
  D. REP AVERAGE SMITH 500
  D. REP AVERAGE SMITH 500