nerdexam
SAS_Institute

A00-212 · Question #21

The following SAS program is submitted: %let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Several SAS data sets exist in the SAUSER library…

The correct answer is B. a report showing the number of columns in each table in SASUSER. See the full explanation below for the reasoning.

Question

The following SAS program is submitted:

%let lib = %upcase(sasuser); proc sql; select nvar from dictionary.tables where libname = "&lib"; quit; Several SAS data sets exist in the SAUSER library. What is generated as output?

Options

  • Aa report showing the numeric columns in each table in SASUSER
  • Ba report showing the number of columns in each table in SASUSER
  • Ca report showing the names of the columns in each table in SASUSER
  • Da report showing the number of numeric columns in each table in SASUSER

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    76% (31)
  • C
    2% (1)
  • D
    7% (3)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice