Select the best answer
for each question. After completing the quiz, check your answers using
the answer key in the appendix.
-
If you specify a CREATE
TABLE statement in your PROC SQL step, which of the following happens?
-
The results of the query
are displayed, and a new table is created.
-
A new table is created,
but it does not contain any summarization that was specified in the
PROC SQL step.
-
A new table is created,
but no report is displayed.
-
Results are grouped
by the value of the summarized column.
-
Which of the following
PROC SQL steps creates a new table by copying only the column structure
(but not the rows) of an existing table?
-
proc sql; create table work.newpayroll as select * from certadv.payrollmaster; ...