Base SAS Provider Recipes

The following table lists the Base SAS provider recipes and their descriptions.

Recipes and Descriptions

Recipe	Task
Connecting to Local Data (Single-User Server)	Start a local server for a single user. In this context, a local installation of Base SAS functions as the 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.
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 subset 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 you read data.
Using SAS Informats When You Write Data	Use SAS informats when you write data.
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.