Hi, I'm trying to run a macro that 1)connects to a SAS server from a remote computer, 2) Submits a command to run a stored process, 3) submits parameters for the stored process. So far, I had partial success in 1) and 2), but I can't submit a parameter for the stored process. I tried the code: SASproc.Execute "TESTVBA", "param=1", but it didn't work at all. I tried to insert a macro "GLOBAL param; *processbody; %let param=;", and also tried to set a prompt "param", but neither worked. Any guess anyone? The VBA code goes as follows: Dim sasObjectFactory As New SASObjectManager.ObjectFactory Dim obSAS As SAS.Workspace Dim LoginDef As SASObjectManager.LoginDef Dim ServerDef As New SASObjectManager.ServerDef ServerDef.Protocol = ProtocolBridge ServerDef.MachineDNSName = "just.asample.net" ServerDef.Port = 8591 Dim SASObjectKeeper As SASObjectManager.ObjectKeeper Dim obLibRef As SAS.Libref Dim sasLanguageEvent As SAS.LanguageService Set sasObjectFactory = New SASObjectManager.ObjectFactory Set obSAS = sasObjectFactory.CreateObjectByServer("Server", True, ServerDef, "someone", "********") Set sasLanguageEvent = obSAS.LanguageService Set SASObjectKeeper = New SASObjectManager.ObjectKeeper SASObjectKeeper.AddObject 1, "Server", obSAS Dim SASproc As SAS.StoredProcessService Set SASproc = obSAS.LanguageService.StoredProcessService SASproc.Repository = "file:f:\path" sasLanguageEvent.Submit ParaSAS SASproc.Execute "TESTVBA", "param=1" End Sub
... View more