Consulting

Results 1 to 5 of 5

Thread: SAS-VBA connection

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 03-21-2016, 02:44 AM #1
    Samo
    Samo is offline
    VBAX Regular
    Joined
    Feb 2016
    Posts
    17
    Location

    SAS-VBA connection

    Hi guys,

    I am trying to set connection for VBA with SAS, can anyone help me please understand where to get
    the server name and data source from in the below statement? is "sas.LocalProvider" standard statement that i can use as it is or do i need to change it and use my own provider name? if so where to get it from? also the Data Source folder is within SAS software I believe in the Libraries isn't it? so what to write?

    obConnection.Provider = "sas.LocalProvider.1"
obConnection.Properties("Data Source") = "folder containing SAS tables"
obConnection.Open



    Regards,

    Samo
    Last edited by SamT; 03-22-2016 at 11:40 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules