nerdexam
SAS_Institute

A00-212 · Question #92

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

The correct answer is D. 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; Given that several SAS data sets exist in the SASUSER library, which one of the following is generated as output?

Options

  • Ano result set
  • Ba syntax error in the log
  • Ca report showing the names of each table in SASUSER
  • Da report showing the number of columns in each table in SASUSER

How the community answered

(35 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    9% (3)
  • D
    83% (29)

Community Discussion

No community discussion yet for this question.

Full A00-212 Practice