Contents
About
Title Page
What's New in SAS/SHARE 9.3
About This Book
Usage
Getting Started with SAS/SHARE
SAS/SHARE: Learning to Use
Frequently Asked Questions (FAQs) about SAS/SHARE
Using SAS/SHARE Software
SAS/SHARE Is a Multi-User Data Server
Accessing SAS Files through an Operating Environment
Accessing SAS Files through a SAS/SHARE Server
Remote Library Services Provides Remote File Access
SAS/SHARE and the SAS Intelligence Platform
SAS/SHARE Software Components
SAS/SHARE Users
Migration and Cross-Version Compatibility (SAS 6 through SAS 9.3)
Managing a SAS/SHARE Server (Server Administrators)
Starting a Server: A Fast-Track Approach
Specifying a Communications Access Method
Predefining SAS Libraries to the Server
Starting a Server
Server Security
Writing a SAS Program to Start a Server
Automating Server Start-Up
Managing a Server, Its Libraries, and Its Users
Writing End-User Applications to Access Shared Data
Accessing Libraries through a Server
Locking Data Objects in Your Programming Environment
SAS Programming Considerations
SQL Programming Considerations
SCL Programming Considerations
SAS Data View Programming Considerations
Using SAS Catalog Entries in Programs
Using SAS/CONNECT with SAS/SHARE
Locking SAS Data Objects
SAS/SHARE Lock Manager Facility
Locking and SAS Data Object Hierarchy
Types of Locks
Locking Objects Explicitly (LOCK Statement)
Locking Explicitly in a SAS Window (LOCK Command)
How Implicit Locking Works in SAS Program Steps
Defaults for Selected SAS Operations
SAS/SHARE Macros for Server Access
Using Macros for Server Library Access
Macros Generated by the SHRMACS Macro
The APPLSYS Macro Library
Interpreting SAS/SHARE Server Log Messages
The SAS/SHARE Server Log
Starting the Server Log
Usage Statistics in the Server Log
Server Log Message Components
Reading the Server Log
Analyzing the Server Log
Starting the Server Log
Using the Server Log Analysis Tools
Customizing Server Log Analysis Programs
Executing the Driver Program (SAS/SHARE)
SLTOOL1 Sample Program (SAS/SHARE)
SLTOOL2 Sample Program (SAS/SHARE)
SLTOOL3 and SLTOOL4 Sample Programs
Reference
The SERVER Procedure
Syntax: SERVER Procedure
PROC SERVER
ALLOCATE SASFILE
ALLOCATE LIBRARY
Overview of the SERVER Procedure
Remote Library Services
Overview of Remote Library Services
LIBNAME Statement
The OPERATE Procedure
Syntax: OPERATE Procedure
OPERATE
Overview of the OPERATE Procedure
Library Management Commands
Server Management Commands
User Management Commands
Specifying a Server
Specifying a Server-Access Password
Specifying a User
Remote SQL Pass-Through (RSPT) Facility
Syntax: RSPT SQL Procedure
PROC SQL
CONNECT TO REMOTE
SELECT... FROM CONNECTION TO
EXECUTE... BY
DISCONNECT FROM
Overview of the RSPT Facility
Examples: RSPT SQL Procedure
Example 1: Processing Data Using RSPT
Example 2: Accessing a DBMS Server
The LOCK Statement and Command
Overview of the LOCK Statement and the LOCK Command
LOCK Statement
LOCK Command
SAS/SHARE Macros
SHRMACS Macro
LIBDEF Macro
LISTLIB Macro
LISTSRV Macro
LISTSRVI Macro
OPERATE Macro
SERVERID Macro
SERVIIDX Macro
SERVINFO Macro
SERVLIB Macro
SETSRV Macro
SHUTSRV Macro
STRTSRV Macro
SAS/SHARE General SAS System Options
COMAMID= System Option
COMAUX1= System Option
TBUFSIZE= System Option
SHARESESSIONCNTL= System Option
VALIDMEMNAME= System Option
Appendixes
Cross-Architecture Access
Audience for Cross-Architecture Access
Cross-Architecture Access: Overview
Cross-Architectural Differences
Cross-Architecture Restrictions and Limitations
Implications of Data Translation
Identical Architectural Groups
Numeric Architectural Groups
Character Architectural Groups
Creating the SAS/SHARE Server Environment
Audience for SAS/SHARE Server Start-Up
All Operating Environments: Setting SAS System Performance and Logging Options
The Operating Environments
OpenVMS: Creating the Server Environment
z/OS: Creating the Server Environment
UNIX: Creating the Server Environment
Windows: Creating the Server Environment
Tuning Tips for Applications That Use SAS/SHARE Software
Authors
Introduction to Tuning Tips for Applications That Use SAS/SHARE Software
Overview of Tuning Tips for Applications That Use SAS/SHARE Software
The SAS Library Model
How Data Flows When You Use SAS Files
Concurrent Access: Update versus Read-only
Computer Resources Used by a Server
Minimizing and Optimizing Resource Consumption
Using Operating Environment Tools
Conclusion
SAS Component Language (SCL) Application
Introduction to the SAS Component Language (SCL) Application
Audience
Inventory and Order System
The Inventory/Order System SCL Application
SAS/SHARE Cross-Version Issues, SAS 9.3
Limitations of Cross-Version Client/Server Access
Consequences of a Client/Server Upgrade to SAS 9.3
Observations and Variables: SAS 9.3 and SAS 8 Differences
SAS Files Access in a Mixed Client/Server Environment
Glossary
Product
Release
SAS/SHARE
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011