Database Reference
In-Depth Information
9.6 Examples
Example 9.1 Assign a Libref to an Excel Worksheet with the OLE-DB Dialog
Box
The SAS code to request that a dialog box be displayed is simple. The following code produces a dialog
box:
libname my_lib OLEDB;
There is no real wizard for this processing, but the dialog boxes do a good job of allowing you to work your
way through the process to connect to an OLE DB connection.
Figure 9.1: Starting the Process of Assigning an OLE DB Connection.
The options available will depend upon the software installed on your computer. For these examples we
will use SAS 9.4 software on a 64-bit O/S. Other versions of SAS provide a similar window when running
on a Windows operating system. The same window appeared on SAS 9.3 on a 32-bit O/S. You may have to
try accessing more than one option on your computer to get the connection to work.
Pressing “Next” or “Connection” will display a screen similar to Figure 9.2. We will enter the required
values onto this screen to point to the data files we want to process. Of course, you will enter values that are
relevant to your data, your computer, or your network configuration. The four screen shots on the next
page step through the process of setting up the connection.
 
 
Search WWH ::




Custom Search