SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 11:

  Given the SAS data set SAUSER.HIGWAY: SASUSER.HIGHWAY

  

  The following SAS program is submitted:

  %macro highway;

  proc sql nonprint;

  %let numgrp=6;

  select distinct status into:group1-:groupandnumgrp from sasuser.highway;

  quit;

  %do i=1 %to andnumgrp;

  proc print data =sasuser.highway;

  where status ="andandgroupandI";

  run;

  %end;

  %mend;

  %highway

  How many reports are produced?

  A. 2
  B. 6
  D. 5
  A. 2

• Question 12:

  Given the SAS data sets:

  

  The SAS program is submitted:

  

  What output will be produced?

  A. Name Lauren Smith Patel Farmer Chang Hiller
  B. Name Chang Chang Lauren
  C. Name Patel Chang
  D. Name Lauren Patel Chang Chang
  A. Name Lauren Smith Patel Farmer Chang Hiller

• Question 13:

  This question will ask you to provide a segment of missing code. Given the SAS data set SASUSER.HIGHWAY:

  

  The following SAS program is submitted:

  

  Which SQL clause stores the text 0-29, 30-49, 60+ in the macro variable GROUPS?

  A. into : GROUPS separated by ` , '
  B. : into GROUPS separated = ` , '
  C. Into : GROUPS delimited by ` , '
  D. : into GROUPS delimited by ` , '
  A. into : GROUPS separated by ` , '

• Question 14:

  Which option forces the use of a specific index from a data set?

  A. INDEX
  B. IDXNAME
  C. IDXWHERE
  D. INDEX
  B. IDXNAME

• Question 15:

  Given the SAS data set WORK TRANSACT:

  

  The following output is desired:

  

  Which SQL statement was used?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  D. Option D

• Question 16:

  The following SAS program is submitted:

  data temp;

  array points{2,3}_temporary_;

  run;

  Which one of the following is the maximum number of elements that are stored?

  A. 2
  B. 3
  C. 5
  D. 6
  D. 6

• Question 17:

  Given the SAS data sets:

  

  A SAS program is submitted and the following is written to SAS to:

  

  What would allow the program to successfully execute without errors?

  A. Qualify the column names with the table names.
  B. Replace the 104 with: Where EMPLOYEE.Name = Any (Select names separated with `,' From WORK.NEWEMPLOYEE Where Salary > 40000);
  C. Replace the where clause with: Where EMPLOYEE.Name = (Select Names delimited with `,' From WORK.NEWEMPLOYEE Where Salary > 40000);
  D. Replace the equal sign with In operator.
  B. Replace the 104 with: Where EMPLOYEE.Name = Any (Select names separated with `,' From WORK.NEWEMPLOYEE Where Salary > 40000);

• Question 18:

  Given the unsorted data set WORK.ORDERS

  

  The following three programs are submitted:

  

  Which program will create a list of unique Customer_ID values in the WORK.ORDERS data set?

  A. Only programs 2 and 3
  B. Only programs 1 and 2
  C. Programs 1, 2, and 3
  D. Only programs 1and 2
  A. Only programs 2 and 3

• Question 19:

  Given the SAS data sets:

  

  The following SAS program is submitted:

  

  What data values are stored in data set WORK.COMBINE?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 20:

  Given the following SAS program:

  proc sql;

  select product, type, sum(sales) as revenue

  from one

  group by product, type;

  quit;

  Which one of the following clauses should be added to the program to sort the output by PRODUCT and decreasing REVENUE?

  A. order by 1, 3
  B. order by 1, 3 desc
  C. orderby product, revenue desc
  D. order by product, desc revenue
  B. order by 1, 3 desc