Contents
About
Title Page
What's New in SAS/CONNECT 9.3
About This Book
What Is SAS/CONNECT?
SAS/CONNECT: Definitions and Services
SAS/CONNECT Terminology
Programming Services
Administering Logging for SAS/CONNECT
Accessibility Features in SAS Products
SAS/CONNECT Options
SAS/CONNECT General SAS System Options
AUTOSIGNON System Option
COMAMID= System Option
CONNECTMETACONNECTION System Option
CONNECTPERSIST System Option
CONNECTREMOTE= System Option
CONNECTSTATUS System Option
CONNECTWAIT System Option
DMR System Option
SASCMD= System Option
SASFRSCR System Option
SASSCRIPT= System Option
SIGNONWAIT System Option
SYSRPUTSYNC System Option
TBUFSIZE= System Option
TCPLISTENTIME= System Option
TCPPORTFIRST= System Option
TCPPORTLAST= System Option
Starting and Stopping SAS/CONNECT Software
Starting and Stopping SAS/CONNECT
Starting SAS and Using Syntax Checking
Starting SAS/CONNECT
Specifying a Communications Access Method
Signing On to the Server
Interfaces for Starting and Stopping SAS/CONNECT
Using SAS/CONNECT Script Files
Overview of SAS/CONNECT Script Files
When to Use a SAS/CONNECT Script
Purpose of a Sign-On Script
Using Passwords in a Script File
Using a Script to Start and Stop SAS/CONNECT
Syntax Rules for SAS/CONNECT Script Statements
Writing Simple SAS/CONNECT Scripts for Signing On and Signing Off
Debugging a SAS/CONNECT Script
Syntax for the SIGNON and the SIGNOFF Statements and Commands
SIGNON Statement and Command
SIGNOFF Command and Statement
Syntax for the FILENAME Statement
FILENAME Statement and Command
SAS Component Language (SCL) Functions and Options
Using SCL to Locate and Store Sample Script Files
COMAMID SCL Function
RLINK SCL Function
RSESSION SCL Function
RSTITLE SCL Function
SAS/CONNECT Script Statements
Summary of SAS/CONNECT Script Statements
ABORT
CALL
ECHO
GOTO
IF
INPUT
LOG
NOTIFY
RETURN
SCANFOR
STOP
TRACE
TYPE
WAITFOR
Sign-On Troubleshooting
Troubleshooting Sign-On Problems
Compute Services
Using Compute Services
Overview of Compute Services
MP CONNECT
Independent Parallelism
Pipeline Parallelism
Benefits of MP CONNECT
Scalability with MP CONNECT
Monitoring MP CONNECT Tasks
Using SAS Explorer to Monitor SAS/CONNECT Tasks
Compute Services and the Output Delivery System
Using the SAS Windowing Environment to Control Remote Processing
Interaction between Compute Services and Macro Processing
Compute Services and Break Windows
Syntax for the RSUBMIT Statement and Command
RSUBMIT Statement and Command
ENDRSUBMIT Statement
RDISPLAY Command and RDISPLAY Statement
RGET Command and RGET Statement
%SYSLPUT Statement
%SYSRPUT Statement
WAITFOR Statement
LISTTASK Statement
KILLTASK Statement
Examples Using Compute Services
The Examples: Compute Services
Example 1: Using MP CONNECT for a Long-Running Remote Task
Example 2: Administering Server Data Sets from a Client
Example 3: Using the CMACVAR= Option with MP CONNECT
Example 4: Using the Output Delivery System with SAS/CONNECT
Example 5: Using MP CONNECT and the WAITFOR Statement
Example 6: Using MP CONNECT with Piping
Example 7: Preventing Pipes from Closing Prematurely
Example 8: Forcing Macro Variables to Be Defined When %SYSRPUT Executes
Example 9: Using Server Software from a Client Session
Syntax for Remote SQL Pass-Through (RSPT)
RSPT Statements
Examples Using Remote SQL Pass-Through (RSPT)
Example 1. RSPT Services: Querying a Table in DB2
Example 2. RSPT Services: Subsetting Remote SAS Data
Examples of Combining Compute Services and Data Transfer Services
Advantages of Combining Compute Services and Data Transfer Services
The Examples
Example 1. Compute Services and Data Transfer Services Combined: Processing in the Client and Server Sessions
Example 2. Compute Services and Data Transfer Services Combined: Sorting and Merging Data
Example 3. Compute Services and Data Transfer Services Combined: Macro Capabilities
Compute Services Troubleshooting
Problems and Solutions when Using the RSUBMIT Statement
Remote Library Services
Remote Library Services (RLS)
Introduction to Remote Library Services
RLS: Advantages
Considerations for Using RLS
Using RLS to Access Types of Data
Using SAS Views with Servers
Using WHERE Processing to Reduce Network Traffic
Syntax for the LIBNAME Statement
LIBNAME Statement
Syntax for the LIBNAME Statement, SASESOCK Engine
LIBNAME Statement, SASESOCK Engine
Examples Using Remote Library Services (RLS)
Example 1. RLS: Accessing Server Data to Print a List of Reports
Example 2. RLS: Accessing Server Data by Using the WHERE Statement
Example 3. RLS: Updating Server Data
Example 4. RLS: An SCL Program That Uses the WHERE Statement
Example 5. RLS: Updating a Server Data Set by Applying a Client Transaction Data Set
Example 6. RLS: Subsetting Server Data for Client Processing and Display
Example of Combining RLS and Data Transfer Services (DTS)
Introduction
Example — RLS and UPLOAD/DOWNLOAD Combined: Distribution of Reports over a Network
Data Transfer Services
Using Data Transfer Services
Introduction to Data Transfer Services
Data Transfer Services: Advantages
Considerations for Using Data Transfer Services
Transfer Status Window
Data Transfer Services Tips
Non-English Keyboards
UPLOAD Procedure
Syntax: UPLOAD Procedure
PROC UPLOAD
WHERE
EXCLUDE
SELECT
TRANTAB
Introduction
Using the VALIDMEMNAME and VALIDVARNAME System Options
PROC UPLOAD Output
DOWNLOAD Procedure
Syntax: DOWNLOAD Procedure
PROC DOWNLOAD
WHERE
EXCLUDE
SELECT
TRANTAB
Introduction
Using the VALIDMEMNAME and VALIDVARNAME System Options
PROC DOWNLOAD Output
Examples of Data Transfer Services (DTS)
Example 1. DTS: Transferring Data by Using WHERE Statements
Example 2. DTS: Transferring Specific Member Types
Example 3. DTS: Transferring Specific Catalog Entry Types
Example 4. DTS: Transferring Generations of SAS Data Sets
Example 5. DTS: Transferring Long Member Names
Example 6. DTS: Transferring Data by Using Data Set Options and Attributes
Example 7. DTS: Transferring Data Set Integrity Constraints
Example 8. DTS: Transferring Numerics by Using the EXTENDSN= and V6TRANSPORT Options
Example 9. DTS: Transferring SAS Utility Files
Example 10. DTS: Distributing an .EXE File from the Server to Multiple Clients
Example 11. DTS: Downloading a Partitioned Data Set from z/OS
Example 12. DTS: Combining Data from Multiple Server Sessions
Example 13. Re-creating an Index for a Data Transfer
Data Transfer Services Troubleshooting
Troubleshooting the UPLOAD and DOWNLOAD Procedures
Appendixes
Cross-Architecture Issues
Translation of SAS Data between Computers That Represent Data Differently
Translation of Floating-Point Numbers between Computers
Encoding Compatibility between SAS/CONNECT Client and Server Sessions
SAS/CONNECT Cross-Version Issues
Factors Affecting Access to SAS Files
Features Exclusive to SAS Releases after SAS 6
RLS: Accessing SAS Files in a Mixed Cross-Version Library
Accessing SAS Data Sets
Accessing SAS Views
Accessing Catalogs
File Format Translation Algorithms
Glossary
Product
Release
SAS/CONNECT
9.3
Type
Usage and Reference
Copyright Date
July 2011
Last Updated
09Jul2011