The following table provides a list of SAS Local Data Provider recipes and their descriptions.
| This recipe... | Explains how to do this... |
|---|---|
| Opening an ADO Connection Object | Open an ADO Connection object. Lists both 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. |
| Specifying a File Format | Specify which SAS file format to use when accessing a data source. Also explains how to access different file formats simultaneously, and explains what happens when no file format is set. |
| Identifying a Data Set to Open | Specify a data set according to the particular SAS provider that you are using. |
| Opening a Password-Protected Data Set | Open a data set that requires a password. |
| Padding Character Data with Blanks | Force the SAS Data Providers to preserve trailing blanks. |
| Reading Missing Values from a Data Set | Test for missing values. |
| Using Formats When You Read Data | Obtain access to SAS formatting features when reading data. |
| Displaying Metadata Specific to SAS | Display metadata that is specific to SAS data sets. |