SAS Institute A00-212 Online Practice Questions and Exam Preparation

SAS Institute A00-212 Online Questions & Answers

• Question 131:

  The variable attributes of SAS data sets ONE and TWO are shown below:

  ONE TWO

  # Variable Type Len Pos # Variable Type Len Pos

  2 sales Num 8 8 2 budget Num 8 8

  1 year Num 8 0 3 sales Char 8 16

  1 year Num 8 0

  Data set ONE contains 100 observations. Data set TWO contains 50 observations. Both data sets are sorted by the variable YEAR.

  The following SAS program is submitted:

  data three;

  merge one two;

  by year;

  run;

  Which one of the following is the result of the program execution?

  A. No messages are written to the SAS log.
  B. ERROR and WARNING messages are written to the SAS log.
  C. Data set THREE is created with two variables and 50 observations.
  D. Data set THREE is created with three variables and 100 observations.
  B. ERROR and WARNING messages are written to the SAS log.

• Question 132:

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

  Given the SAS data set WORK EXAM:

  TotalScore

  *

  The following SAS program is submitted:

  

  The following output is desired:

  TotalScore

  Which WHERE expression completes the program and generates the desired output?

  A. Where TotalScore is not missing
  B. Where TotalScore ne null
  C. Where TotalScore is not
  D. Where TotalScore ne missing
  A. Where TotalScore is not missing

• Question 133:

  The SAS data set WORK.TEMPDATA contains the variables FMTNAME, START and The following SAS program is submitted:

  Proc format cntlin=wor.tempdata;

  Run;

  What is the result of submitting the FORMAT procedure step?

  A. It uses the WORK.TEMPDATA SAS data set as input to create the format
  B. All formats created will be stored in two WORK.TEMPDATA SAS data set
  C. An ERROR message is written to the SAS log because the program is incomplete
  D. NO formats are created in this step
  A. It uses the WORK.TEMPDATA SAS data set as input to create the format

• Question 134:

  The following SAS program is submitted:

  %macro one (input);

  %two;

  %put the value is anddate;

  %mend;

  %macro two;

  data _null_;

  call symput('date','12SEP2008');

  run;

  %mend;

  %let date=31DEC2006;

  %one(anddate)

  What is the result when the %PUT statement executes?

  A. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the ONE macro
  B. A macro variable DATE with the value 12SEP2008 is retrieved from the local symbol table for the TWO macro
  C. A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table
  D. A macro variable DATE with the value 31DEC2006 is retrieved from the global symbol table
  C. A macro variable DATE with the value 12SEP2008 is retrieved from the global symbol table

• Question 135:

  The following SAS program is submitted:

  %macro check(num=4);

  %let result=%eval(andnm gt 5);

  %put result is andresult;

  %mend;

  %check (num=10)

  What is written to the SAS log?

  A. result is true
  B. result is 10 gt 5
  C. result is 1
  D. result is 0
  C. result is 1

• Question 136:

  Which macro statement would remove the macro variable mv_Info from the symbol table?

  A. %symercase Mv_Info;
  B. %symdel and Mv_Info;
  C. %symdel Mv_Info;
  D. %mdelete and Mv_Info;
  C. %symdel Mv_Info;

• Question 137:

  The following SAS program is submitted:

  data temp:

  array points { 2,3 } (10,15,20,25,30,35);

  run;

  What impact does the ARRAY statement have in the program Data vector (PDV)?

  A. The variables named POINTS10, POINTS15,POINTS20,POINTS25,POINTS30, POINTS35 are created in the PDV
  B. No variables are created in the PDV
  C. The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV
  D. The variables named POINTS11, POINTS12, POINTS13, POINTS21, POINTS22, POINTS23 are created in the PDV
  C. The variables named POINTS1, POINTS2, POINTS4, POINTS5, POINTS6 are created in the PDV

• Question 138:

  Given the following SAS statement: %let idcode = Prod567;

  Which one of the following statements stores the value 567 in the macro variable CODENUM?

  A. %let codenum = substr(andidcode,length(andidcode)-2);
  B. %let codenum = substr(andidcode,length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);
  D. %let codenum = %substr(andidcode,%length(andidcode)-3);
  C. %let codenum = %substr(andidcode,%length(andidcode)-2);

• Question 139:

  Which of the following is true about the COMPRESS=YES data set option?

  A. It is most effective with numeric data that represents large numeric values
  B. It is most effective with character data that contains patterns, rather than simple repetitions
  C. It uses the Ross Data Compression method to compress numeric data
  D. It is most effective with character data that contains repeated characters
  D. It is most effective with character data that contains repeated characters

• Question 140:

  Which one of the following SAS procedures changes a permanent format of a variable stored in a SAS data set?

  A. MODIFY
  B. FORMAT
  C. CONTENTS
  D. DATASETS
  D. DATASETS