1. 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 SASUSER library. What
is generated as output?
A.a report showing the numeric columns in each table in SASUSER
B.a report showing the number of columns in each table in SASUSER
C.a report showing the names of the columns in each table in SASUSER
D.a report showing the number of numeric columns in each table in SASUSER
Answer: B
2. The following SAS program is submitted: proc sql; select * from dictionary.tables; quit; What is
generated as output?
A.metadata on all tables in all libraries
B.metadata on all tables in the WORK library only
C.metadata on the DICTIONARY.TABLES table only
D.metadata on all tables in the DICTIONARY library only
Answer: A
Testpassport professional provide SAS Institute Systems Certification A00-212 the newest Q&A, completely covers A00-212 test original topic. With our complete SAS Institute Systems Certification resources, you will minimize your SAS Institute Systems Certification cost and be ready to pass your A00-212 tests on Your First Try, 100% Money Back Guarantee included!
