nerdexam
SAS_Institute

A00-212 · Question #101

Given the following SAS data set SASUSER.HIGHWAY: The following SAS program is submitted: %macro highway; proc sql noprint; select count(distinct status) into :numgrp from sasuser.highway; %let…

The correct answer is C. 2. See the full explanation below for the reasoning.

Question

Given the following SAS data set SASUSER.HIGHWAY:

The following SAS program is submitted:

%macro highway; proc sql noprint; select count(distinct status) into :numgrp from sasuser.highway; %let numgrp = &numgrp; 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 by the above program?

Exhibit

A00-212 question #101 exhibit

Options

  • A0
  • B1
  • C2
  • D5

How the community answered

(27 responses)
  • A
    7% (2)
  • B
    15% (4)
  • C
    74% (20)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice