SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 81:

  Which SAS integrity constraint type ensures that a specific set or range of values are the only values in a variable?

  A. CHECK
  B. NOT NULL
  C. PRIMARY KEY
  D. UNIQUE
  A. CHECK

• Question 82:

  Which one of the following programs contains a syntax error?

  A. proc sql; select product.*, cost.unitcost, sales.quantity from product p, cost c, sales s where p.item = c.item and
  B. item = s.item; quit;
  C. proc sql; select product.*, cost.unitcost, sales.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;
  D. proc sql; select p.*, c.unitcost, s.quantity from product as p, cost as c, sales as s where p.item = c.item and
  E. item = s.item; quit;
  F. proc sql; select p.*, c.unitcost, s.quantity from product, cost, sales where product.item = cost.item and product.item = sales.item; quit;
  D. proc sql; select p.*, c.unitcost, s.quantity from product as p, cost as c, sales as s where p.item = c.item and

• Question 83:

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

• Question 84:

  Given the following SAS data set ONE:

  ONE NUM VAR 1 A 2 B 3 C Which one of the following SQL programs deletes the SAS data set ONE?

  A. proc sql; delete table one; quit;
  B. proc sql; alter table one drop num, var; quit;
  C. proc sql; drop table one; quit;
  D. proc sql; delete from one; quit;
  C. proc sql; drop table one; quit;

• Question 85:

  The following SAS program is submitted:

  data new(bufsize = 6144 bufno = 4);

  set old;

  run;

  What is the difference between the usage of BUFFSIZE= and BUFNO= options?

  A. BUFSIZE=specifies the size of the output buffer in kilobytes; BUFNO=specifies the number of output buffers
  B. BUFSIZE= specifies the size of the input buffer in bytes; BUFFNO= specifies the number of input buffers
  C. BUFSIZE= specifies the size of the input buffer in kilobytes; BUFNO=specifies the number of input buffers
  D. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers
  D. BUFSIZE= specifies the size of the output buffer in bytes; BUFNO= specifies the number of output buffers

• Question 86:

  Given the SAS data sets:

  

  The following SAS program is submitted:

  

  What output is produced?

  A. Name Charlie Omar
  B. Name Omar Nguyen
  C. Name Charlie Nguyen Nguyen
  D. Name Charlie Omar Nguyen
  A. Name Charlie Omar

• Question 87:

  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 = 8 then b = 'Small '; else if a in(1, 2) then b = 'Medium'; else if a = 6 then b = 'Large'; run;
  B. 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;
  C. 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';
  D. data new; set temp; if a = 6 then b = 'Large '; if a in (1, 2) then b = 'Small'; run;
  C. 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';

• Question 88:

  Which one of the following statements about compressed SAS data sets is always true?

  A. Each observation is treated as a single string of bytes.
  B. Each observation occupies the same number of bytes.
  C. An updated observation is stored in its original location.
  D. New observations are added to the end of the SAS data set.
  A. Each observation is treated as a single string of bytes.

• Question 89:

  The following SAS program is submitted:

  %macro test(var);

  proc print data = sasuser.class;

  where age > andvar;

  run;

  %mend;

  Which type of parameter is the macro variable VAR?

  A. default
  B. keyword
  C. positional
  D. command
  C. positional

• Question 90:

  The following SAS program is submitted:

  %let value = .5;

  %let add = 5;

  %let newval = %eval(andvalue + andadd);

  Which one of the following is the resulting value of the macro variable NEWVAL?

  A. 5
  B. 5.5
  C. .5 + 5
  D. null
  D. null