SAS 9.1.3 Language Reference: Concepts, Third Edition, Volumes 1 and 2

ISBN: 1590478401
EAN: 2147483647

Year: 2004
Pages: 258

Authors: SAS Publishing

BUY ON AMAZON

Table of Contents
BackCover
SAS 9.1.3 Language Reference-Concepts
Part 1: Windowing Environment Concepts
Chapter 1: Essential Concepts of Base SAS Software
Overview of Base SAS Software
Components of the SAS Language
Ways to Run Your SAS Session
Customizing Your SAS Session
Conceptual Information about Base SAS Software
Chapter 2: SAS Processing
Types of Input to a SAS Program
The DATA Step
The PROC Step
Chapter 3: Rules for Words and Names in the SAS Language
Names in the SAS Language
Chapter 4: SAS Language Elements
Data Set Options
Formats and Informats
Functions and CALL Routines
ARM Macros
Statements
SAS System Options
Chapter 5: SAS Variables
SAS Variable Attributes
Ways to Create Variables
Variable Type Conversions
Aligning Variable Values
Automatic Variables
SAS Variable Lists
Dropping, Keeping, and Renaming Variables
Numeric Precision in SAS Software
Chapter 6: Missing Values
Special Missing Values
Order of Missing Values
When Variable Values Are Automatically Set to Missing by SAS
When Missing Values Are Generated by SAS
Working with Missing Values
Chapter 7: Expressions
Examples of SAS Expressions
SAS Constants in Expressions
SAS Variables in Expressions
SAS Functions in Expressions
SAS Operators in Expressions
Chapter 8: Dates, Times, and Intervals
About Date and Time Intervals
Chapter 9: Error Processing and Debugging
Error Processing in SAS
Debugging Logic Errors in the DATA Step
Chapter 10: SAS Output
Routing SAS Output
The SAS Log
Traditional SAS Listing Output
Changing the Destination of the Log and the Output
Output Delivery System
Customized ODS Output
Summary of ODS
Chapter 11: BY-Group Processing in SAS Programs
References for BY-Group Processing
Chapter 12: WHERE-Expression Processing
Where to Use a WHERE Expression
Syntax of WHERE Expression
Combining Expressions by Using Logical Operators
Constructing Efficient WHERE Expressions
Processing a Segment of Data That Is Conditionally Selected
Deciding Whether to Use a WHERE Expression or a Subsetting IF Statement
Chapter 13: Optimizing System Performance
Collecting and Interpreting Performance Statistics
Techniques for Optimizing IO
Techniques for Optimizing Memory Usage
Techniques for Optimizing CPU Performance
Calculating Data Set Size
Chapter 14: Support for Parallel Processing
Threaded IO
Threaded Application Processing
Chapter 15: Monitoring Performance Using Application Response Measurement (ARM)
How Does ARM Work?
Will ARM Affect an Application s Performance?
Using the ARM Interface
Examples of Gathering Performance Data
Chapter 16: The SAS Registry
Managing the SAS Registry
Configuring Your Registry
Chapter 17: Printing with SAS
Managing Printing Tasks with the Universal Printing User Interface
Configuring Universal Printing with Programming Statements
Forms Printing
Part 2: Windowing Environment Concepts
Chapter 18: Introduction to the SAS Windowing Environment
Main Windows of the SAS Windowing Environment
Chapter 19: Managing Your Data in the SAS Windowing Environment
Copying and Viewing Files in a Data Library
Using the Workspace to Manipulate Data in a Data Set
Importing and Exporting Data
Part 3: DATA Step Concepts
Chapter 20: DATA Step Processing
Overview of DATA Step Processing
Processing a DATA Step: A Walkthrough
About DATA Step Execution
About Creating a SAS Data Set with a DATA Step
Writing a Report with a DATA Step
The DATA Step and ODS
Chapter 21: Reading Raw Data
Ways to Read Raw Data
Kinds of Data
Sources of Raw Data
Reading Raw Data with the INPUT Statement
How SAS Handles Invalid Data
Reading Missing Values in Raw Data
Reading Binary Data
Reading Column-Binary Data
Chapter 22: BY-Group Processing in the DATA Step
Syntax for BY-Group Processing
Understanding BY Groups
Invoking BY-Group Processing
Determining Whether the Data Requires Preprocessing for BY-Group Processing
Preprocessing Input Data for BY-Group Processing
How the DATA Step Identifies BY Groups
Processing BY-Groups in the DATA Step
Chapter 23: Reading, Combining, and Modifying SAS Data Sets
Overview of Tools
Reading SAS Data Sets
Combining SAS Data Sets: Basic Concepts
Combining SAS Data Sets: Methods
Error Checking When Using Indexes to Randomly Access or Update Data
Chapter 24: Using DATA Step Component Objects
Using the Hash Object
Using the Hash Iterator Object
Chapter 25: Array Processing
A Conceptual View of Arrays
Syntax for Defining and Referencing an Array
Processing Simple Arrays
Variations on Basic Array Processing
Multidimensional Arrays: Creating and Processing
Specifying Array Bounds
Examples of Array Processing
Part 4: SAS Files Concepts
Chapter 26: SAS Data Libraries
Library Engines
Library Names
Library Concatenation
Permanent and Temporary Libraries
SAS System Libraries
Sequential Data Libraries
Tools for Managing Libraries
Chapter 27: SAS Data Sets
Descriptor Information for a SAS Data Set
Data Set Names
Special SAS Data Sets
Sorted Data Sets
Tools for Managing Data Sets
Viewing and Editing SAS Data Sets
Chapter 28: SAS Data Files
Differences between Data Files and Data Views
Understanding an Audit Trail
Understanding Generation Data Sets
Understanding Integrity Constraints
Understanding SAS Indexes
Compressing Data Files
Chapter 29: SAS Data Views
Benefits of Using SAS Data Views
When to Use SAS Data Views
DATA Step Views
PROC SQL Views
Comparing DATA Step and PROC SQL Views
SASACCESS Views
Chapter 30: Stored Compiled DATA Step Programs
Uses for Stored Compiled DATA Step Programs
Restrictions and Requirements for Stored Compiled DATA Step Programs
How SAS Processes Stored Compiled DATA Step Programs
Creating a Stored Compiled DATA Step Program
Executing a Stored Compiled DATA Step Program
Differences between Stored Compiled DATA Step Programs and DATA Step Views
Examples of DATA Step Programs
Chapter 31: DICTIONARY Tables
How to View DICTIONARY Tables
Chapter 32: SAS Catalogs
SAS Catalog Names
Tools for Managing SAS Catalogs
Profile Catalog
Catalog Concatenation
Chapter 33: About SASACCESS Software
Dynamic LIBNAME Engine
SQL Procedure Pass-Through Facility
ACCESS Procedure and Interface View Engine
DBLOAD Procedure
Interface DATA Step Engine
Chapter 34: Processing Data Using Cross-Environment Data Access (CEDA)
Advantages of CEDA
SAS File Processing with CEDA
Processing a File with CEDA
Alternatives to Using CEDA
Creating New Files in a Foreign Data Representation
Examples of Using CEDA
Chapter 35: SAS 9.1 Compatibility with SAS Files From Earlier Releases
Comparing SAS System 9 to Earlier Releases
Using SAS Library Engines
Chapter 36: File Protection
Assigning Passwords
Removing or Changing Passwords
Using Password-Protected SAS Files in DATA and PROC Steps
How SAS Handles Incorrect Passwords
Assigning Complete Protection with the PWData Set Option
Using Passwords with Views
SAS Data File Encryption
Chapter 37: SAS Engines
Specifying an Engine
How Engines Work with SAS Files
Engine Characteristics
About Library Engines
Special-Purpose Engines
Chapter 38: SAS File Management
Moving SAS Files Between Operating Environments
Repairing Damaged SAS Files
Chapter 39: External Files
Referencing External Files Directly
Referencing External Files Indirectly
Referencing Many External Files Efficiently
Referencing External Files with Other Access Methods
Working with External Files
Part 5: Industry Protocols Used in SAS
Chapter 40: The SMTP E-Mail Interface
System Options That Control SMTP E-Mail
Statements That Control SMTP E-mail
Chapter 41: Universal Unique Identifiers
Using SAS Language Elements to Assign UUIDs
Part 6: Appendices
Appendix 1: Recommended Reading
Index
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Index_X
Index_Y
Index_Z
List of Figures
List of Tables
List of Outputs