topic Re: how to connect SAS Studio from excel using VB script in Administration and Deployment

how to connect SAS Studio from excel using VB script

Venky_SASfellow — Tue, 01 Aug 2017 15:49:57 GMT

Hello there,

I got stuck here with the below situation.

Quick Context - I am working on some excel based UI using VB script which connect to SAS(PC SAS) to execute all my data prep and other analysis codes. Some part of the code will export the results into CSV. Later, I will take those results and show in my UI.

Now, I got to move all my SAS codes into SAS Studio. Otherwords, I got to connect SAS studio from excel.

I am sure some body would have figured out this. Would really appreciate any help which could help me to overcome this.

Please keep posted your thoughts & suggestions.

Thank you,

Venky

Re: how to connect SAS Studio from excel using VB script

Reeza — Tue, 01 Aug 2017 16:07:54 GMT

SAS Studio is an interface that connects to a server. Getting your server to connect to your process is going to be interesting.

Re: how to connect SAS Studio from excel using VB script

LinusH — Tue, 01 Aug 2017 18:50:42 GMT

If you still want Excel to be the interface for driving your data prep, SAS Add-in for MS Office is probably the easiest way to go.