how to connect SAS Studio from excel using VB script

[Venky_SASfellow]

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

[Reeza]

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

[LinusH]

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.