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…

Sign in or unlock A00-212 to reveal the answer and full explanation for question #21. The question stem and answer options stay visible for context.

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

Unlock A00-212 to see the answer

You've previewed enough free A00-212 questions. Unlock A00-212 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Full A00-212 Practice