A00-212

A00-212 practice questions, page 2 of 8, with answer review and explanations.

Question 6

The following SAS program is submitted: %micro test(var); %let jobs=BLACKSMITH WORDSMITH SWORDSMITH; %let type=%index(&jobs, &var); %put type = &type; %mend; %test(SMITH) What is the value of the macro variable TYPE when the %PUT statement executes?

  1. 0
  2. Null
  3. 6
  4. 3

Question 7

The following SAS program is submitted: %macro check(num=4); %let result=%eval(&nm gt 5); %put result is &result; %mend; %check (num=10) What is written to the SAS log?

  1. result is true
  2. result is 10 gt 5
  3. result is 1
  4. result is 0

Question 8

The following SAS program is submitted: data temp; length 1 b 3 x; infile 'file reference'; input a b x; run; What is the result?

  1. The data set TEMP is not created because variables A and B have invalid lengths
  2. The data set TEMP is created, but variable X is not created
  3. The data set TEMP is not created because variable A has an invalid length
  4. The data set TEMP is created and variable X has a length of 8

Question 9

Given the SAS data sets ONE and TWO: The following SAS program is submitted: Proc sql; Select two.*,budget from one two on one.year=two.year, Quit; The following output is desired: Which JOIN operator completes the program and generates the desired output?

  1. FULL JOIN
  2. INNER JOIN
  3. LEFT JOIN
  4. RIGHT JOIN

Question 10

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-:group&numgrp from sasuser.highway; quit; %do i=1 %to &numgrp; proc print data =sasuser.highway; where status ="&&group&I"; run; %end; %mend; %highway How many reports are produced?

  1. 2
  2. 6
  3. 0
  4. 5