SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 91:

  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
  B. A report showing the number of columns in each table in SASUSER

• Question 92:

  Given the SAS date sets CLASS1 and CLASS2 CLASS1 CLASS2 NAME COURSE NAME COURSE Lauren MATH1 Smith MATH2 Patel MATH1 Farmer MATH2 Chang MATH1 Patel MATH2 Chang MATH3 Hiller MATH2 The following SAS program is submitted: Proc sql; Select name from CLASS1 select name from CLASS; quit; The following output is desired NAME Chang Chang Lauren Which SQL set operator completes the program and generates the desired output?

  A. UNION ALL
  B. EXCEPT ALL
  C. INTERSECT ALL
  D. OUTER UNION ALL
  B. EXCEPT ALL

• Question 93:

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

  A. MODIFY and CHANGE statements
  B. RENAME statement only
  C. CHANGE statement only
  D. MODIFY and RENAME statements
  C. CHANGE statement only

• Question 94:

  The following SAS program is submitted:

  %let first = yourname;

  %let last = first;

  %put andandandlast;

  Which one of the following is the result in the log of the %PUT statement?

  A. first
  B. andfirst
  C. yourname
  D. andyourname
  C. yourname

• Question 95:

  The following SAS program is submitted:

  proc sql;

  select *

  from dictionary.tables;

  quit;

  Which one of the following is reported?

  A. metadata on all tables in all libraries
  B. metadata on all tables in the WORK library only
  C. metadata on all tables in the SASUSER library only
  D. metadata on all tables in the DICTIONARY library only
  A. metadata on all tables in all libraries

• Question 96:

  Which one of the following statements is true?

  A. The WHERE statement can be executed conditionally as part of an IF statement.
  B. The WHERE statement selects observations before they are brought into the PDV.
  C. The subsetting IF statement works on observations before they are read into the PDV.
  D. The WHERE and subsetting IF statements can be used interchangeably in all SAS programs.
  B. The WHERE statement selects observations before they are brought into the PDV.

• Question 97:

  Which one of the following is the purpose of the IDXNAME= data set option?

  A. It instructs SAS to name and store a specific index.
  B. It instructs SAS to store an index in a particular location.
  C. It instructs SAS to use a specific index for WHERE processing.
  D. It instructs SAS to use any available index for WHERE processing.
  C. It instructs SAS to use a specific index for WHERE processing.

• Question 98:

  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?

  A. data two; Set one; Where totrev>1000; Totrev=sum(price*quantity); Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;
  B. data two; Set one; totrev=sum(price*quantity); where totrev>1000; totcost=sum(fixed,variable); profit=sum(totrev,-totcost); run;
  C. data two; Set one; Totrev=sum(price*quantity); If totrev>1000; Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;
  D. data two; Set one; Totrev = sum(price*quantity); Totcost= sum(fixed,variable); If totrev>1000; Profit=sum(totrev,-totcost); Run;
  C. data two; Set one; Totrev=sum(price*quantity); If totrev>1000; Totcost=sum(fixed,variable); Profit=sum(totrev,-totcost); Run;

• Question 99:

  This question will ask you to provide a segment of missing code.

  Given the SAS data set SASUSER.ORDERS:

  

  The following SAS program is submitted:

  

  Which statement completes the program completely so that it will produce a report with the total number of orders for California?

  A. Call syntax (`num' California)
  B. Num = California
  C. andnum = California
  D. Syntax (`num', California)
  B. Num = California

• Question 100:

  The following SAS program is submitted:

  %macro check(num=4);

  %let result=%sysevalf(andnum+0.5);

  %put result is andresult;

  %mend;

  %check(num=10)

  What is the written to the SAS log?

  A. result is
  B. result is 10
  C. result is 10.5
  D. result is 10+0.5
  C. result is 10.5