SAS(R) 9.2 Providers for OLE DB: Cookbook
Base SAS Provider Recipes
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.
|