Architecting, installing and maintaining your SAS environment

how to connect SAS Studio from excel using VB script

Reply
Occasional Learner
Posts: 1

how to connect SAS Studio from excel using VB script

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

Super User
Posts: 19,815

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

Posted in reply to Venky_SASfellow

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

Super User
Posts: 5,430

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

Posted in reply to Venky_SASfellow
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.
Data never sleeps
Ask a Question
Discussion stats
  • 2 replies
  • 108 views
  • 1 like
  • 3 in conversation