Need Help for SAS Automation

Reply
Occasional Contributor
Posts: 5

Need Help for SAS Automation

How to open(not run) sas file using vbscript or Javascript?

SAS Super FREQ
Posts: 8,743

Re: Need Help for SAS Automation

Hi:

  What do you mean by "SAS file" -- a SAS catalog, such as a format catalog? a SAS program file, such as a .SAS file? or a SAS dataset?

  And, have you searched support.sas.com for examples of opening a SAS file with VBScript? Although, I'm having a hard time envisioning what you would want to do with a SAS file (program or dataset or catalog) in JavaScript or VBScript.

cynthia

Occasional Contributor
Posts: 5

Re: Need Help for SAS Automation

Hi Cynthia,

              Thank you for your kind attentation and consideration.

              I wanted to open SAS Program file(.sas) using Javascript or VBScript. I searched on support.sas.com, finally i got one sas paper.

              & paper is http://www2.sas.com/proceedings/sugi30/226-30.pdf. & solution is

Dim wshell

Set wshell = CreateObject("WScript.Shell")

wshell.Run Chr(34) & "C:\PROGRA~1\SASINS~1\SAS\V8\CORE\SASEXE\SASOACT.EXE" & Chr(34) & " action=Open datatype=SASFile filename='c:\wutemp\test.sas' progid=SAS.Application.8"

Thanks,

Saurabh.

Ask a Question
Discussion stats
  • 2 replies
  • 213 views
  • 0 likes
  • 2 in conversation