SAS_Institute
A00-202 · Question #19
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 A. 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
- Aa report showing the number of columns in each table in SASUSER
- Ba report showing the names of each table in SASUSER
- Cno result set
- Da syntax error in the log
How the community answered
(40 responses)- A80% (32)
- B5% (2)
- C3% (1)
- D13% (5)
Community Discussion
No community discussion yet for this question.