SAS/SHARE Provider Recipes

The following table lists SAS/SHARE provider recipes and their descriptions.

Recipes and Descriptions

Recipe	Task
Connecting to Local Data	Open an ADO Connection object to access locally stored data.
Connecting to a Remote SAS Workspace Server	Connect to a remote SAS/SHARE server.
Prompting Users for Connection Information by Displaying the Data Link Properties Dialog Box	Prompt users for connection information at run time by displaying the Data Link Properties dialog box.
Using a Microsoft Data Link (.udl) File to Provide Persistent Connection Information	Reference connection information that is stored in a Microsoft Data Link (.udl) file.
Controlling Data Access Permissions with a Connection	Set permissions on your data source.
Connecting to a Specific SAS/SHARE Server Version	Explicitly request access to a Version 7 or Version 8 SAS/SHARE server.
Identifying a Data Set and Returning Results	Open a specific data set and return either static or dynamic results. Your options depend on which SAS provider you are using.
Opening a Password-Protected Data Set	Open a password-protected data set.
Accessing Third-Party Data through SAS/ACCESS Engines	Access third-party data stores that are available through your licensed SAS/ACCESS engines.
Displaying Metadata That Is Specific to SAS Data Sets	Display metadata that is specific to SAS data sets.
Creating and Deleting Data Sets	Create and delete data sets.
Subsetting Data Sets for Read-Only Sequential Access	Execute SQL queries and commands in order to create subsets of data sets for read-only, sequential access.
Subsetting Data Sets for Random and Update Access	Use the WHERE clause with the SAS SQL procedure to subset data sets for random and update access.
Using SAS Formats When You Read Data	Use SAS formats when reading data.
Using SAS Informats When You Write Data	Use SAS informats when writing data.
Reading User-Defined SAS Formats and Informats	Read user-defined SAS formats and informats.
Padding Character Data with Blanks	Preserve trailing blanks.
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.
Updating Recordsets	Perform recordset updates, including batch updates.
Implementing a Locking Strategy	Lock records, especially during update access.