SAS-VBA connection

[Samo]

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

[SamT]

Bump

[Tommy]

https://support.sas.com/documentation/cdl/en/odbcdref/63284/PDF/default/odbcdref.pdf
The link will take you to the ODBC reference for SAS.

If you need help with what the document says let us know.

[Samo]

Thanks a lot, i will check the link and see if it is helpful.

Samo

[Samo]

Hi Tommy,

I am not sure this has anything to do with accessing SAS from VBA in excel, I just wanted to know the Provider and Data Source as in my questions above, any suggestions?