Quiz

Select the best answer for each question. After completing the quiz, check your answers using the answer key in the appendix.
  1. PROC SQL options are specified in
    1. the PROC SQL statement.
    2. an OPTIONS statement.
    3. a SELECT statement.
    4. the OPTIONS procedure.
  2. Which of the following SQL options restricts the number of rows that PROC SQL takes as input from any single source?
    1. OUTOBS=
    2. INOBS=
    3. OBS=
    4. none of the above
  3. Which PROC SQL step creates the output shown below?
    Table with EmpID, JobCode, LastName, FirstName columns
    Table with row numbers
    1. proc sql nonumber outobs=10;
   select *
      from sasuser.flightattendants
      where jobcode='FA1';
   select *
      from sasuser.flightattendants
      where jobcode='FA2';
    2. proc sql number;
   select *
      from sasuser.flightattendants
      where jobcode='FA1';
reset nonumber outobs=10;
   select *
      from sasuser.flightattendants
      where jobcode='FA2';
    3. proc sql nonumber;
   select *
      from sasuser.flightattendants
      where jobcode='FA1';
reset number outobs=10;
   select *
      from sasuser.flightattendants
      where jobcode='FA2';
    4. proc sql;
   select *
      from sasuser.flightattendants
      where jobcode='FA1';
reset outobs=10;
    select *
       from sasuser.flightattendants
       where jobcode='FA2';
  4. Which of the following options does not affect the appearance of HTML, PDF, or RTF output?
    1. NUMBER | NONUMBER
    2. DOUBLE | NODOUBLE
    3. FLOW | NOFLOW | FLOW=n | FLOW=n m
    4. b and c
  5. Which of the following statements is true regarding the STIMER option in PROC SQL?
    1. The STIMER option in PROC SQL writes timing information for each statement to the SAS log.
    2. The STIMER option in PROC SQL writes only cumulative timing information for the entire procedure to the SAS log.
    3. When using the STIMER option in PROC SQL, the SAS system option STIMER must also be in effect.
    4. a and c
  6. A Dictionary table contains which of the following?
    1. information about SAS libraries.
    2. information about SAS data sets.
    3. information about SAS macros.
    4. all of the above
  7. Dictionary tables are
    1. created each time they are referenced in a SAS program.
    2. updated automatically.
    3. limited to Read-Only access.
    4. all of the above
  8. Dictionary tables can be accessed
    1. by running a PROC SQL query against the table, using the Dictionary libref.
    2. by referring to the PROC SQL view of the table that is stored in the Sashelp library.
    3. by referring to the PROC SQL view of the table that is stored in the Sasuser library.
    4. a and b
  9. Which of the following PROC SQL steps displays information about the Dictionary table Dictionary.Titles? 
    1. proc sql;                
   describe dictionary.titles;
    2. proc sql;                
   describe table dictionary.titles;
    3. proc sql describe table dictionary.titles;
    4. proc sql describe dictionary titles;
  10. 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? 
    1. proc sql; 
   select memname, modate, nvar, nobs
      from dictionary.tables 
      where libname='SASUSER';
    2. proc sql; 
   select memname, modate, nvar, nobs
      from dictionary.tables 
      where libname='Sasuser';
    3. proc sql; 
   select memname, modate, nvar, nobs
      from 'SASUSER'
      where table=dictionary.tables;
    4. proc sql; 
   select SASUSER
      from dictionary.tables 
      where cols= 'memname, modate, nvar, nobs';
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
52.15.129.90