SAS Institute SAS Institute Certifications A00-212 Questions & Answers

• Question 31:

  The following SAS program is submitted:

  %let first=yourname;

  %let last=first;

  %put andandandlast;

  What is written to the SAS Log?

  A. First

  B. Yourname

  C. andandFirst

  D. andyourname

  Correct Answer: B

• Question 32:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  YEAR QTR BUDGET YEAR QTR SALES

  2001 3 500 2001 4 300

  2001 4 400 2002 1 600

  2002 1 700

  The following SAS program is submitted:

  proc sql;

  select one.*, sales

  from one, two;

  quit;

  Which one of the following reports is generated?

  A. YEAR QTR BUDGET SALES 2001 4 400 300 2002 1 700 600

  B. YEAR QTR BUDGET SALES 2001 3 500 2001 4 400 300 2002 1 700 600

  C. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 600

  D. YEAR QTR BUDGET SALES 2001 3 500 300 2001 4 400 300 2002 1 700 300 2001 3 500 600 2001 4 400 600 2002 1 700 600

  Correct Answer: D

• Question 33:

  The following SAS program is submitted:

  %let lib=%upcase(sauser); proc sql;

  select nvar form dictionary.tables where libname='andlib"; quit;

  Several SAS data sets exist in the SAUSER library.

  What is generated as output?

  A. A report showing the names of the columns in each table in SASUSER

  B. A report showing the number of columns in each table in SASUSER

  C. A report showing the numeric columns in each table in SASUSER

  D. A report showing the number of numeric columns in each table in SASUSER

  Correct Answer: B

• Question 34:

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

  A. RENAME statement only

  B. CHANGE statement only

  C. MODIFY and RENAME statements

  D. MODIFY and CHANGE statements

  Correct Answer: B

• Question 35:

  The DICTIONARY.MACROS table stores information about which of the following?

  A. user defined macro variables only

  B. system defined macro variables only

  C. both user and system defined macro variables

  D. macros stored in the autocall macro library only

  Correct Answer: C

• Question 36:

  The following SAS program is submitted:

  data one; do i = 1 to 10;

  ptobs = ceil(ranuni(0) * totobs);

  set temp point = ptobs

  nobs = totobs;

  output;

  end;

  stop;

  run;

  The SAS data set TEMP contains 2,500,000 observations. Which one of the following represents the possible values for PTOBS?

  A. any integer between 1 and 10

  B. any real number between 0 and 1

  C. any integer between 1 and 2,500,000

  D. any real number between 1 and 2,500,000

  Correct Answer: C

• Question 37:

  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;

  Correct Answer: D

• Question 38:

  The SAS data set WORK.CHECK has a variable named Id_Code in it. Which SQL statement would create an index on this variable?

  A. Define index (Id_Code) in WORK.CHECK;

  B. Create index (Id_Code) on WORK.CHECK;

  C. Make index = Id_Code from WORK.CHECK;

  D. Create index Id_Code on WORK.CHECK;

  Correct Answer: D

• Question 39:

  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.

  Correct Answer: A

• Question 40:

  The following SAS program is submitted:

  

  The report will not successfully run and will produce an error message in the log. What causes the error message in the log?

  A. The SELECT clause for the in-line view in the wrong location

  B. The ORDER BY clause in an in-line view is not allowed

  C. The ORDER BY clause is a query when using an in-line views is most allowed

  D. The in-line view syntax in the wrong location

  Correct Answer: B