Local Provider Recipes

The following table lists recipes that apply to the local provider.

Recipes and Descriptions

Recipe	Task
Connecting to Local Data	Open an ADO Connection object to access locally stored data.
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.
Managing File Formats with the Local Provider	Specify which SAS file format to use to access a data source and access different file formats simultaneously.
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.
Displaying Metadata That Is Specific to SAS Data Sets	Display metadata that is specific to SAS data sets.
Using SAS Formats When You Read Data	Use SAS formats to read data.
Padding Character Data with Blanks	Preserve trailing blanks.
Reading Missing Values from a Data Set	Test for missing values.