SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Connect to SAS Server using VBA?

Reply
New Contributor
Posts: 2

Connect to SAS Server using VBA?

Hi,

I'm trying to establish a connection to the SAS Server and create a workspace using VBA. However, I'm having a problem trying to figure out how to browse the libraries and access datasets on the server from Excel. Is there a call for the Add-In dialog in VBA that would allow me to access the libraries?
SAS Super FREQ
Posts: 305

Re: Connect to SAS Server using VBA?

After creating a connection to the workspace server, the DataService property on the workspace object will allow you to list, assign, deassign libraries, etc. Once you have a Libref object you can list data sets in that library and open a data set. To start, look at the DataService object in the help file C:\Program Files\SAS\Shared Files\Integration Technologies\sas.chm and in the ObjectBrowser in the VBA editor.
Ask a Question
Discussion stats
  • 1 reply
  • 591 views
  • 0 likes
  • 2 in conversation