SAS® 9.4 Providers for OLE DB: Cookbook : SAS Help Center

Part 1Introduction

Introduction to the SAS Providers for OLE DB

System Requirements and Installation

Part 2Getting Started

Finding Recipes

Learning about SAS Connections

Part 3Connection Recipes

Opening an ADO Connection Object

Managing Connections

Part 4Data Management Recipes

Accessing Specific or Protected Data

Creating, Subsetting, and Deleting Data Sets

Specifying How to Display Data

Managing Missing Values

Managing Updates

Part 5Tips and Best Practices

Tuning the Providers for Performance

Writing Code That Returns Provider Information

Part 6Troubleshooting

Handling Error Objects

Part 7Appendixes

ADO: Supported Cursor and Lock Type Combinations

ADO: Supported Methods and Properties

OLE DB Properties

OLE DB Interfaces

OLE DB: Format Processing

OLE DB: Column Mapping and Binding

Customized User Help for the Data Link Properties Dialog Box

Recommended Reading

Copyright © SAS Institute Inc. All Rights Reserved.

Last updated: July 18, 2017