Select the best answer
for each question. After completing the quiz, check your answers using
the answer key in the appendix.
-
PROC SQL options are
specified in
-
Which of the following
SQL options restricts the number of rows that PROC SQL takes as input
from any single source?
-
Which PROC SQL step
creates the output shown below?
-
proc sql nonumber outobs=10;
select *
from sasuser.flightattendants
where jobcode='FA1';
select *
from sasuser.flightattendants
where jobcode='FA2';
-
proc sql number;
select *
from sasuser.flightattendants
where jobcode='FA1';
reset nonumber outobs=10;
select *
from sasuser.flightattendants
where jobcode='FA2';
-
proc sql nonumber;
select *
from sasuser.flightattendants
where jobcode='FA1';
reset number outobs=10;
select *
from sasuser.flightattendants
where jobcode='FA2';
-
proc sql;
select *
from sasuser.flightattendants
where jobcode='FA1';
reset outobs=10;
select *
from sasuser.flightattendants
where jobcode='FA2';
-
Which of the following
options does not affect the appearance of HTML, PDF, or RTF output?
-
-
-
FLOW | NOFLOW | FLOW=
n |
FLOW=
n m
-
-
Which of the following
statements is true regarding the STIMER option in PROC SQL?
-
The STIMER option in
PROC SQL writes timing information for each statement to the SAS log.
-
The STIMER option in
PROC SQL writes only cumulative timing information for the entire
procedure to the SAS log.
-
When using the STIMER
option in PROC SQL, the SAS system option STIMER must also be in effect.
-
-
A Dictionary table contains
which of the following?
-
information about SAS
libraries.
-
information about SAS
data sets.
-
information about SAS
macros.
-
-
-
created each time they
are referenced in a SAS program.
-
-
limited to Read-Only
access.
-
-
Dictionary tables can
be accessed
-
by running a PROC SQL
query against the table, using the Dictionary libref.
-
by referring to the
PROC SQL view of the table that is stored in the Sashelp library.
-
by referring to the
PROC SQL view of the table that is stored in the Sasuser library.
-
-
Which of the following
PROC SQL steps displays information about the Dictionary table Dictionary.Titles?
-
proc sql;
describe dictionary.titles;
-
proc sql;
describe table dictionary.titles;
-
proc sql describe table dictionary.titles;
-
proc sql describe dictionary titles;
-
Which of the following
PROC SQL steps displays the name (Memname), modification date (Modate),
number of variables (Nvar), and the number of observations (Nobs)
for each table in the Sasuser library?
-
proc sql;
select memname, modate, nvar, nobs
from dictionary.tables
where libname='SASUSER';
-
proc sql;
select memname, modate, nvar, nobs
from dictionary.tables
where libname='Sasuser';
-
proc sql;
select memname, modate, nvar, nobs
from 'SASUSER'
where table=dictionary.tables;
-
proc sql;
select SASUSER
from dictionary.tables
where cols= 'memname, modate, nvar, nobs';