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;
quit;
-
proc sql;
create table work.newpayroll
like certadv.payrollmaster;
quit;
-
proc sql;
create table work.newpayroll
copy certadv.payrollmaster;
quit;
-
proc sql;
create table work.newpayroll
describe certadv.payrollmaster;
quit;
-
Which of the following
PROC SQL steps creates a table that contains rows for the level-1
flight attendants only?
-
proc sql;
create table work.newpayroll as
select *
from certadv.payrollmaster
where jobcode='FA1';
quit;
-
proc sql;
create work.newpayroll as
select *
from certadv.payrollmaster
where jobcode='FA1';
quit;
-
proc sql;
create table work.newpayroll
copy certadv.payrollmaster
where jobcode='FA1';
quit;
-
proc sql;
create table work.newpayroll as
certadv.payrollmaster
where jobcode='FA1';
quit;
-
Which of the following
statements is used to add new rows to a table?
-
Which of the following
displays the structure of a table in the SAS log?
-
proc sql;
describe as
select *
from certadv.payrollmaster;
quit;
-
proc sql;
describe contents certadv.payrollmaster;
quit;
-
proc sql;
describe table certadv.payrollmaster;
quit;
-
proc sql;
describe * from certadv.payrollmaster;
quit;
-
Which of the following
creates an empty table that contains the two columns FullName and
Age?
-
proc sql;
create table work.names
(FullName char(25), Age num);
quit;
-
proc sql;
create table work.names as
(FullName char(25), Age num);
quit;
-
proc sql;
create work.names
(FullName char(25), Age num);
quit;
-
proc sql;
create table work.names
set (FullName char(25), Age num);
quit;