SAS Bridge to ESRI  

Use SAS Bridge for ESRI Objects in a Custom Application

SAS Bridge for ESRI  

The components for SAS Bridge for ESRI are built on a set of classes that encapsulate the following:

  • Starting and stopping a SAS workspace.
  • Processing an ArcMap feature table.
  • Creating a SAS data set.

You can use these classes to create your own custom export applications and macros. For example, you can create an application that exports data to SAS, and then runs other processes without intervention. 

There is both a simple way to use these classes to export data and a more advanced approach. The more advanced approach requires more coding but enables greater flexibility and customization. Whichever way you choose, your code can run in either silent mode or verbose mode. In verbose mode, a progress dialog tracks the export progress.  In silent mode, the progress dialog does not appear

To use these classes in a VBA macro in ArcMap follow these steps:

Define a VBA macro in ArcMap:
  1. Select Tools Macros Visual Basic Editor from the ArcMap menubar.
  2. Select Tools References from the menu bar of the Visual Basic Editor.
  3. Select the following from the References window:
    • SAS Integrated Object Model (IOM) Type Library
    • SAS WorkspaceManager 1.1 Type Library
    • SAS Bridge for ESRI 1.0 Type Library
  4. Select Insert Module from the menu bar of the Visual Basic Editor.
Type the code:
  1. Simplified VBA code.
  2. More advanced VBA code.
Run the macro:
  1. Select Tools Macros Macros from the ArcMap menu bar.
  2. Select the macro you want to run.
  3. Click Run.
For more information, see SAS Bridge for ESRI Classes.