SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 21:

  Which SQL procedure program deletes rows from the data set CLASS?

  A. proc sql; Select * from class Where age
  B. proc sql; Modify table class Delete where age
  C. proc sql; Delete from class Where age
  D. proc sql; Alter from class Delete where age
  C. proc sql; Delete from class Where age

• Question 22:

  Which one of the following options controls the pagesize of a SAS data set?

  A. SIZE=
  B. BUFNO=
  C. BUFSIZE=
  D. PAGESIZE=
  C. BUFSIZE=

• Question 23:

  Text is sent to the SAS compiler as a result of macro execution. Which one of the following SAS system options writes that text to the log?

  A. MPRINT
  B. MLOGIC
  C. MSOURCE
  D. SOURCE2
  A. MPRINT

• Question 24:

  The following SAS program is submitted:

  

  How will the variable be listed?

  A. Height Weight Name Age
  B. Weight Height
  C. Weight Height Name Age
  D. Name Age Weight Height
  D. Name Age Weight Height

• Question 25:

  The following SAS program is submitted:

  %let var = chicago, 1;

  data a;

  var = 'new york, 2';

  newvar = %scan(andvar,2,%str());

  run;

  Which one of the following explains why the program fails to execute?

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

• Question 26:

  Given the following partial SAS log:

  NOTE: SQL table SASHELP.CLASS was created line

  Create table SASHELP.CLASS(bufsize=4096)

  (

  Name char(8);

  Gender Char(1);

  Age num;

  Height num;

  Weight num

  );

  Which SQL procedure statement generated this output?

  A. DESCRIBE TABLE
  B. LIST TABLE
  C. VALIDATE TABLE
  D. CREATE TABLE
  A. DESCRIBE TABLE

• Question 27:

  The following SAS program is submitted:

  proc contents data = testdata.one;

  run;

  Which one of the following SQL statements produces similar information about the column attributes as the above CONTENTS procedure?

  A. proc sql; show testdata.one; quit;
  B. proc sql; describe testdata.one; quit;
  C. proc sql; show table testdata.one; quit;
  D. proc sql; describe table testdata.one; quit;
  D. proc sql; describe table testdata.one; quit;

• Question 28:

  The following SAS program is submitted:

  %let name = Patel's Restaurant;

  Which one of the following statements avoids problems associated with the unbalanced quotation mark?

  A. %let name = Patel%'s Restaurant;
  B. %let name = %str(Patel's Restaurant);
  C. %let name = Patel%str(')s Restaurant;
  D. %let name = %str(Patel%'s Restaurant);
  D. %let name = %str(Patel%'s Restaurant);

• Question 29:

  What is an advantage of using a hash object in a SAS DATA step?

  A. The hash object persists after the DATA step has executed
  B. The hash object key values can be multiple numeric and character data values
  C. The hash object automatically sorts the data
  D. The hash object does not require unique keys
  B. The hash object key values can be multiple numeric and character data values

• Question 30:

  The following SAS program is submitted:

  %micro cols1;

  name age;

  %mend;

  %macro cols2;

  height weight

  %mend

  proc print data=sashelp.class;

  Run

  Which VAR statement successfully completes the program and produces a report?

  A. var heigh %cols1;
  B. var %cols1 %cols2 height;
  C. var %cols1 height;
  D. var %cols2 %cols1;
  A. var heigh %cols1;