Resources

SAS 9.1 Data Providers: ADO/OLE DB Cookbook Index

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

A

ADO, supported methods and properties
ADO MD
ADOX

C

CATALOGS schema rowset
choosing a data provider
column mapping and binding
column types
COLUMNS schema rowset
connections, opening
cross-platform file support
cubes
CUBES schema rowset
cursor types, supported
customized properties

D

data file types, supported
descriptions, providers
DIMENSIONS schema rowset

F

feature comparison
files, specifying formats
formats
    OLE DB processing
    reading data
    user-written
FUNCTIONS schema rowset

G

H

HIERARCHIES schema rowset

I

informats, user-written
informats, writing data
in-memory data set caching
installation
    SAS IOM Data Provider
    SAS Local Data Provider
    SAS OLAP Data Provider
    SAS/SHARE Data Provider
    testing
IOM workspaces, reusing
ISASColumnsInfo
ISASDataSetInfo
ISASDataSetInfo90
ITableDefinition Interface

K

L

LDAP
LEVELS schema rowset
librefs, assigning
local servers
locking strategies
lock types, supported

M

MDX
MEASURES schema rowset
MEMBERS Schema Rowset
metadata, displaying for SAS data sets
Microsoft Data Link API
missing values
reading
writing
multidimensional data, reading

O

OLE DB interfaces
OLE DB Properties
opening an ADO connection

P

padding character data
password-protected data sets
performance tuning
permissions, controlling
PROPERTIES schema rowset
PROVIDER_TYPES schema rowset

R

recipe indexes
    local provider
    IOM provider
    OLAP provider
    SAS/SHARE provider
recommended reading
remote connections
    IOM server
    OLAP server
    SAS/SHARE server

S

SAS data file types, supported
SAS/ACCESS data sets, reading
SASFORMAT Structure
schema rowsets
SETS schema rowset
SQL
subsetting data sets
suggested reading
system requirements

T

TABLES schema rowset
testing installation
third-party data stores
transport files

U

updating records

V

version information

W

what's new in SAS 9 and 9.1