The following table provides a list of SAS/SHARE Data Provider recipes and their descriptions.
| This recipe... | Explains how to do this... |
|---|---|
| Opening an ADO Connection Object | Open an ADO Connection object. Lists required and optional connection properties for each of the SAS Data Providers. |
| Making Connections by Using the Microsoft Data Link API | Use the Microsoft Data Link API to prompt users for OLE DB connection information at run time and to provide persistent connection information for the SAS Data Providers. |
| Controlling Data Access Permissions with a Connection | Set permissions on your data source. |
| Connecting to a Remote SAS/SHARE Server | Connect to a remote SAS/SHARE server. |
| Connecting to a Specific SAS/SHARE Server Version | Access a specific version of the SAS/SHARE Server. |
| Starting a Single-User Local Server with the SAS/SHARE Provider | Start a local server for use by a single user to access data that is located on the same machine. Lists the applicable ADO Connection object properties. Explains how to modify the TCP/IP services file. |
| Identifying a Data Set to Open | Specify a data set depending on which SAS provider you are using. |
| Opening a Password-Protected Data Set | Open a data set that requires a password. Discusses the three types of data set passwords. |
| Padding Character Data with Blanks | Force the SAS Data Providers to preserve trailing blanks. |
| Updating Records | Perform recordset updates, including how to handle batch. |
| Creating and Deleting Data Sets | Create and delete data sets. Explains how to use SQL CREATE TABLE and DROP TABLE statements; how to use Microsoft ActiveX Data Object Extensions for DDL and Security (ADOX); and how to use OLE DB's ITableDefinition interface. |
| Executing SQL Queries and Commands | Execute SQL queries and commands. |
| Subsetting Data Sets for Update Access | Subset data sets for random and update access using the SAS WHERE clause. |
| Implementing a Locking Strategy | Lock records that you are updating to prevent data loss. |
| Reading Missing Values from a Data Set | Test for missing values. |
| Writing Missing Values to a Data Set | Write missing values to a data set. |
| Using Formats When You Read Data | Obtain access to SAS formatting features when reading data. |
| Using Informats When You Write Data | Obtain access to SAS informatting features when writing data. |
| Displaying Metadata Specific to SAS | Display metadata that is specific to SAS data sets. |