SAS Institute A00-212 Exam
SAS Advanced Programming Exam for SAS 9 (Page 7 )

Updated On: 26-Jan-2026

The following SAS program is submitted:
%macro test(var);
%let jobs = BLACKSMITH WORDSMITH SWORDSMITH;
%let type = %index(&jobs,&var);
%mend;
%test(SMITH)

Which one of the following is the resulting value of the macro variable TYPE?

  1. 0
  2. 3
  3. 6
  4. null

Answer(s): C



Which one of the following SAS integrity constraint types ensures that a specific set or range of values are the only values in a variable?

  1. CHECK
  2. UNIQUE
  3. FORMAT
  4. DISTINCT

Answer(s): A



Which one of the following options displays the value of a macro variable in the SAS log?

  1. MACRO
  2. SOURCE
  3. SOURCE2
  4. SYMBOLGEN

Answer(s): D



The following SAS ARRAY statement is submitted:

array score{*} a4 - a10, a25 ;

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

  1. 3
  2. 7
  3. 8
  4. 11

Answer(s): C



When is it appropriate to create indexes on a SAS data set for efficient processing?

  1. if small subsets of data are often retrieved
  2. if the key variable has very few unique values
  3. if the data are often used for BY group processing
  4. if the SAS data set file page count is less than three pages

Answer(s): A



Viewing page 7 of 38
Viewing questions 31 - 35 out of 184 questions



Post your Comments and Discuss SAS Institute A00-212 exam prep with other Community members:

Join the A00-212 Discussion