SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 41:

  Given the following SAS data sets ONE and TWO:

  ONE TWO

  OBS COMMON X OBS COMMON Y

  1 A 10 1 A 1

  2 A 13 2 A 3 3 A 14 3 B 4

  4 B 9 4 B 2

  5 C 8 5 C 5

  6 C 14

  The following SAS DATA step is submitted:

  data combine;

  merge one two;

  by common;

  run;

  Which one of the following represents the data values stored in data set COMBINE?

  A. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5
  B. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 9 4 4 C 8 5
  C. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 B 14 4 4 B 9 2 5 C 8 5
  D. OBS COMMON X Y 1 A 10 1 2 A 13 1 3 A 14 1 4 A 10 3 5 A 13 3 6 A 14 3 7 B 9 4 8 B 9 2 9 C 8 5 10 C 14 5
  A. OBS COMMON X Y 1 A 10 1 2 A 13 3 3 A 14 3 4 B 9 4 5 B 9 2 6 C 8 5 7 C 14 5

• Question 42:

  At the start of a new SAS session; the following program is submitted:

  %macro one;

  data _null_;

  call symput('proc','measn);

  run;

  proc andproc data=sashelp.class;

  run;

  %mend;

  %one()

  What is the result?

  A. The marco variable PRCO is stored in the SAS catalog WORK.SASMACR
  B. The program fails to execute because PROC is a reserved word
  C. The macro variable PROC is stored in the local symbol table
  D. The macro variable PROC is stored in the global symbol table
  D. The macro variable PROC is stored in the global symbol table

• Question 43:

  A data set stored on a network drive has the following characteristics:

  14 Million observations 400 numeric variables 0 character variables of length 20 Binary compression

  A DATA Step query requires only 3 character and 15 numeric variables from this data set. What is the best way to reduce computer resource utilization in this DATA Step?

  A. A KEEP= data set option used on the SET Statement
  B. A KEEP Statement used within the DATA Step
  C. A KEEP= data set option used on the DATA Statement
  D. A DROP= data set option used on the DATA Statement
  D. A DROP= data set option used on the DATA Statement

• Question 44:

  The following SAS program is submitted:

  %let a=cat;

  %macro animal(a=frog);

  %let a=bird;

  %mend;

  %animal(a=pig)

  %put a is anda;

  What is written to the SAS log?

  A. a is pig
  B. a set cat
  C. a is frog
  D. a is bird
  B. a set cat

• Question 45:

  The following SAS program is submitted:

  data temp;

  set sasuser.history(kep=date);

  format date qtr

  if first.date then total=0;

  total+1;

  if last.date;

  run;

  proc print data=temp;

  run

  SASUSER.HISTORY is sorted by the SAS date variable DATE.

  The following output is required:

  Date Total

  1 13

  3 15

  4 25

  Which By statement completes the data step and successfully generates the required output?

  A. by groupformat date;
  B. by formateed date;
  C. by notsorted date;
  D. by date qtr
  A. by groupformat date;

• Question 46:

  Given the following SAS data set ONE:

  ONE

  CATEGORY AGE SALARY BONUS

  M 28 200 20

  M 25 100 10

  M 28 300 10

  M 33 300 30

  F 18 100 50

  F 25 200 10

  F 35 400 50

  The following SQL program is submitted:

  proc sql;

  create table two as

  select distinct age

  from one

  where age < 33;

  quit;

  How many rows are written to the SAS data set TWO?

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

• Question 47:

  In the data step merge, the BY variables in all data sets must have the same:

  A. Name and length
  B. Name, type, and length
  C. Name and type
  D. Name
  B. Name, type, and length

• Question 48:

  The following SAS program is submitted:

  % let product = merchandise;

  And the following message is written to the SAS log:

  The value is "merchandise"

  Which macro statement wrote this message?

  A. % put the value is "andproduct.";
  B. % put the value is ""andproduct."";
  C. % put the value is "%quote(andproduct).";
  D. % put the value is ` " `andproduct. ` " ` ;
  A. % put the value is "andproduct.";

• Question 49:

  Which one of the following statements is true regarding a SAS DATA step view?

  A. It allows write capabilities.
  B. It contains global statements.
  C. It contains data and a descriptor portion.
  D. It contains a partially compiled DATA step.
  D. It contains a partially compiled DATA step.

• Question 50:

  Given the following SAS data set SASUSER.HIGHWAY:

  SASUSER.HIGHWAY

  STEERING SEATBELT SPEED STATUS COUNT

  absent no 0-29 serious 31

  absent no 0-29 not 1419

  absent no 30-49 serious 191

  absent no 30-49 not 2004

  absent no 50+ serious 216

  The following SAS program is submitted:

  %macro highway;

  proc sql noprint;

  select count(distinct status)

  into :numgrp

  from sasuser.highway;

  %let numgrp = andnumgrp;

  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 by the above program?

  B. 1
  C. 2
  D. 5
  C. 2