Skip to Main Content
SAS Certified Professional Prep Guide
book

SAS Certified Professional Prep Guide

by SAS Institute
October 2019
Intermediate to advanced content levelIntermediate to advanced
430 pages
19h 4m
English
SAS Institute
Content preview from SAS Certified Professional Prep Guide

PROC SQL Options

A Brief Overview

The SQL procedure offers a variety of options that control processing. Some options control execution. For example, you can limit the number of rows that are read or written during a query. Other options control output. For example, you can control the number of rows to be displayed in your output.

PROC SQL Statement Syntax

Syntax, PROC SQL statement:
PROC SQL <option(s)>;
option(s)
names the option(s) to be used.
After you specify an option, it remains in effect until you change it or you reset it.
The following tables list the options that are covered in this section. A description and an example of each option appear in the following sections.
Table 1.1 Controlling Execution Options ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SAS Certified Specialist Prep Guide

SAS Certified Specialist Prep Guide

SAS Institute
SAS in Practice

SAS in Practice

Ekta Saraogi

Publisher Resources

ISBN: 9781642954692