Chapter 8: Managing Processing Using Proc SQL

10 Questions | Total Attempts: 53

SettingsSettingsSettings
Please wait...
SQL Quizzes & Trivia

Practice for the SAS advance certification exam


Questions and Answers
  • 1. 
    PROC SQL options are specified in
    • A. 

      The PROC SQL statement

    • B. 

      An OPTIONS statement.

    • C. 

      A SELECT statement.

    • D. 

      The OPTIONS procedure.

  • 2. 
    Which of the following options restricts the number of rows that PROC SQL takes as input from any single source?
    • A. 

      OUTOBS=

    • B. 

      INOBS=

    • C. 

      OBS=

    • D. 

      None of the above

  • 3. 
    Which PROC SQL step creates the output shown below?
    • A. 

      proc sql nonumber outobs=10; select * from sasuser.flightattendants where jobcode='FA1'; select * from sasuser.flightattendants where jobcode='FA2';

    • B. 

      proc sql number; select * from sasuser.flightattendants where jobcode='FA1'; reset nonumber outobs=10; select * from sasuser.flightattendants where jobcode='FA2';

    • C. 

      proc sql nonumber; select * from sasuser.flightattendants where jobcode='FA1'; reset number outobs=10; select * from sasuser.flightattendants where jobcode='FA2';

    • D. 

      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?
    • A. 

      NUMBER | NONUMBER

    • B. 

      DOUBLE | NODOUBLE

    • C. 

      FLOW | NOFLOW | FLOW=n | FLOW=n m

    • D. 

      B and c

  • 5. 
    Which of the following statements is true regarding the STIMER option in PROC SQL?
    • A. 

      The STIMER option in PROC SQL writes timing information for each statement to the SAS log.

    • B. 

      The STIMER option in PROC SQL writes only cumulative timing information for the entire procedure to the SAS log.

    • C. 

      When using the STIMER option in PROC SQL, the SAS system option STIMER must also be in effect.

    • D. 

      A and c

  • 6. 
    A Dictionary table contains
    • A. 

      Information about SAS data libraries.

    • B. 

      Information about SAS data sets.

    • C. 

      Information about SAS macros.

    • D. 

      All of the above

  • 7. 
    Dictionary tables are
    • A. 

      Created each time they are referenced in a SAS program.

    • B. 

      Updated automatically.

    • C. 

      Limited to read-only access.

    • D. 

      All of the above

  • 8. 
    Dictionary tables can be accessed
    • A. 

      By running a PROC SQL query against the table, using the Dictionary libref.

    • B. 

      By referring to the PROC SQL view of the table that is stored in the Sashelp library.

    • C. 

      By referring to the PROC SQL view of the table that is stored in the Sasuser library.

    • D. 

      A and b

  • 9. 
    Which of the following PROC SQL steps displays information about the Dictionary table Dictionary.Titles?
    • A. 

      proc sql; describe dictionary.titles;

    • B. 

      proc sql; describe table dictionary.titles;

    • C. 

      proc sql describe table dictionary.titles;

    • D. 

      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?
    • A. 

      proc sql; select memname, modate, nvar, nobs from dictionary.tables where libname='SASUSER';

    • B. 

      proc sql; select memname, modate, nvar, nobs from dictionary.tables where libname='Sasuser';

    • C. 

      proc sql; select memname, modate, nvar, nobs from 'SASUSER' where table=dictionary.tables;

    • D. 

      proc sql; select SASUSER from dictionary.tables where cols= 'memname, modate, nvar, nobs';

Related Topics
Back to Top Back to top