Book Contents		Master Index

S

sample data

SAS/ACCESS engine

SAS/ACCESS LIBNAME statement

advantages of

arguments

clearing librefs from SAS data libraries

combining PROC SQL views with SAS data sets

CONNECTION= option

data from a DBMS

DBCONINIT= option

DBCONTERM= option

DEFER= option

examples

FREQ procedure with

GCHART procedure with

naming conventions and

options

performance and

PRESERVE_COL_NAMES= option

PRESERVE_TAB_NAMES= option

SAS/ACCESS engine and

syntax

WHERE statement with

writing data library attributes to SAS log

SAS/ACCESS LIBNAME statement, CA-OpenIngres

data conversions

engine connection options

example

options

SAS/ACCESS LIBNAME statement, DB2 under OS/390

connection restrictions

data conversions

engine connection options

options

specifying

SAS/ACCESS LIBNAME statement, DB2 under UNIX and PC hosts

data conversions

engine connection options

example

options

specifying

SAS/ACCESS LIBNAME statement, Informix

data conversions

engine connection options

example

options

SAS/ACCESS LIBNAME statement, ODBC

engine connection options

examples

options

SAS/ACCESS LIBNAME statement, OLE DB

engine connection options

examples

options

SAS/ACCESS LIBNAME statement, ORACLE

data conversions

engine connection options

example

options

SAS/ACCESS LIBNAME statement, SYBASE

data conversions

engine connection options

examples

options

SAS/ACCESS LIBNAME statement, Teradata

data conversions

engine connection options

examples "LIBNAME Statement: Teradata Specifics"

examples "LIBNAME Statement: Teradata Specifics"

lock options

options

performance options

SAS/ACCESS procedures

examples of Version 6 procedures

Version 8 compatibility for Version 6 procedures

SAS/ACCESS software

choosing features

comparing features

SAS/ACCESS views

SAS data libraries

clearing librefs from

writing attributes to SAS log

SAS data set options

SEE: data set options

SAS data sets

combining DBMS data and SAS data

combining with PROC SQL views "Joining DBMS and SAS Data"

combining with PROC SQL views "Joining DBMS and SAS Data"

creating from DBMS data

creating with UPDATE statement

passwords for

reading data from multiple data sets

updating with DBMS data

SAS data views

SAS log, writing data library attributes to

SAS system options

CA-OpenIngres

DB2 under OS/390

macro facility and

SAS System security

SAS views

SASDATEFMT= data set option

CA-OpenIngres

DB2 under UNIX and PC hosts

Informix

ODBC

OLE DB

ORACLE

Teradata

SASDATEINFMT= data set option, OLE DB

SASTRACE system option

SASTRACELOC system option

SAVE statement, CV2ODBC procedure

SCHEMA= connection option (CA-OpenIngres)

SCHEMA= data set option

CA-OpenIngres

DB2 under UNIX and PC hosts

Informix

ODBC

OLE DB

ORACLE

SYBASE

Teradata

SCHEMA= option, SAS/ACCESS LIBNAME statement

DB2 under UNIX and PC hosts

Informix

ODBC

OLE DB

ORACLE

SYBASE

Teradata

schemas

CA-OpenIngres "SAS/ACCESS LIBNAME Statement: CA-OpenIngres Specifics"

CA-OpenIngres "SCHEMA="

DB2 under UNIX and PC hosts

Informix

ODBC

OLE DB

ORACLE

SYBASE

Teradata

security of data

SEGMENT_NAME= data set option, SYBASE

SELECT statement, ACCESS procedure

selecting and combining data

SERVER= connection argument

Informix

SYBASE

SERVER= connection option

DB2 under OS/390

Informix

SYBASE

SERVER= statement, ACCESS procedure

DB2 under OS/390

SYBASE

SERVER= statement, DBLOAD procedure

DB2 under OS/390

SYBASE

SHOW_SYNONYMS= option, LIBNAME statement (ORACLE)

sorting DBMS data

SPOOL= option, SAS/ACCESS LIBNAME statement

CA-OpenIngres

DB2 under OS/390

DB2 under UNIX and PC hosts

Informix

ODBC

ORACLE

Teradata

SQL procedure

accessing DBMS tables on different nodes or databases

advanced features

case sensitivity in

columns, creating

CONNECT statement "SQL Procedure Pass-Through Facility: CA-OpenIngres Specifics"

CONNECT statement "SQL Procedure Pass-Through Facility: DB2 Specifics"

creating DBMS tables

DBMS data with

deleting DBMS data

Direct SQL Join feature

enhancements for Versions 7 and 8

executing non-query statements

GROUP BY clause

inserting DBMS data

joining data from various sources

long names in

naming conventions and

passing joins to the DBMS

PROC SQL tables

querying a single table

querying multiple tables

reading DBMS data "Reading and Updating Data with the SQL Procedure"

reading DBMS data "Reading and Updating Data with the SQL Procedure"

retrieving data for queries or views

SAS data views

selecting and combining data

SQL Query Window

submitting DBMS-specific statements

submitting DBMS-specific, nonquery statements

syntax

updating DBMS data "Reading and Updating Data with the SQL Procedure"

updating DBMS data "Reading and Updating Data with the SQL Procedure"

updating DBMS data "Using the SQL Procedure with DBMS Data"

SQL Procedure Pass-Through Facility

advantages of

CA-OpenIngres

combining PROC SQL views with SAS data sets

CONNECT statement

CONNECT statement, DB2 under UNIX and PC hosts

CONNECT statement, Informix

CONNECT statement, ODBC

CONNECT statement, OLE DB

CONNECT statement, ORACLE

CONNECTION TO component "CONNECTION TO Component"

CONNECTION TO component "CONNECTION TO Component"

CONNECTION TO component, ODBC

CONNECTION TO component, OLE DB

data conversions, Informix

DB2 under OS/390

DB2 under UNIX and PC hosts

DISCONNECT statement

examples

EXECUTE statement "EXECUTE Statement"

EXECUTE statement "EXECUTE Statement"

Informix

MDX statements

name compatibility, Version 6

ODBC

OLAP data and

OLE DB

ORACLE

Oracle Rdb

Pass-Through queries in subqueries

reading data

retrieving DBMS data with queries

return codes

statements

SYBASE

syntax

Teradata

updating data

SQL Query Window

SQL statement

DB2UTIL procedure

DBLOAD procedure

SQL*Loader, ORACLE

SQLIN= option, PROC DB2UTIL statement

SQLOUT= option, PROC DB2UTIL statement

SQLXMSG macro variable

SQLXRC macro variable

SSID= connection option, DB2 under OS/390

SSID= option, PROC DB2UTIL statement

SSID= statement, DB2 under OS/390

ACCESS procedure

DBLOAD procedure

statistics calculation

stored procedures

string data

DB2 under OS/390

DB2 under UNIX and PC hosts

Oracle Rdb

Teradata

STRINGDATES= option, SAS/ACCESS LIBNAME statement

DB2 under UNIX and PC hosts

ODBC

OLE DB

SUBMIT statement, CV2ODBC procedure

subqueries

SUBSET statement, ACCESS procedure

subsetting DBMS data

SYBASE

ACCESS procedure

autocommit

bulk copy utility

bulk rows "BULK_BUFFER="

bulk rows "READ_BUFFER="

case sensitivity

connection arguments

connections

data conversions, ACCESS procedure

data conversions, DBLOAD procedure

data conversions, LIBNAME statement

data set options

data types

data types, user-defined

engine connection options

inserting text

isolation levels "READ_ISOLATION_LEVEL="

isolation levels "UPDATE_ISOLATION_LEVEL="

linking between databases

locks "READ_LOCK_TYPE="

locks "UPDATE_LOCK_TYPE="

naming conventions

national language support

NULL values

SAS/ACCESS LIBNAME statement

schemas

segment names

SQL Procedure Pass-Through Facility

Versions 7 and 8

SYBBUFSZ= connection argument (SYBASE)

SYBBUFSZ= statement, ACCESS procedure (SYBASE)

SYSDBMSG macro variable

SYSDBRC macro variable

system options

CA-OpenIngres

DB2 under OS/390

macro facility and