SAS Quizzes, Questions & Answers

Statistical Analysis System’s aren't just for sports fans and politics. Read more

Top Trending SAS Quizzes

Chapter 8: Managing Processing Using Proc SQL

This quiz in Chapter 8 focuses on managing processing using PROC SQL in SAS. It tests knowledge on syntax, options like INOBS, and specific SQL commands for data handling and querying, enhancing skills in database management and...

Questions: 10 | Attempts: 136 | Last updated: Mar 21, 2023

Sample Question 1
PROC SQL options are specified in

The PROC SQL statement

An OPTIONS statement.

A SELECT statement.

The OPTIONS procedure.

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

OUTOBS=

INOBS=

OBS=

None of the above

Sample Question 3
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';

SAS Quizzes, Questions & Answers

Popular SAS Topics

Top Trending SAS Quizzes