topic Re: Save SAS list in SAS Procedures

Save SAS list

Dreamer — Wed, 14 Jan 2015 16:35:25 GMT

Hi,

I am writing a VB script to run a SAS code. It works perfectly.

It runs the SAS code and saves log at requried location.

But I'm not able to save the SAS list. I tried various options but no luck

Below is a part of VB Script that I'm using:

----------------------------------------------------------------------------------------------------------

Set app = CreateObject("SASEGObjectModel.Application.6.1")

If Checkerror("CreateObject") = True Then

Exit Sub

End If

' open the project

Set prjObject = app.New()

If Checkerror("app.New") = True Then

Exit Sub

End If

' open the file and put the text into the fileString variable

Dim fileSys, fReadStream, fileString

Set fileSys = CreateObject("Scripting.FileSystemObject")

Set fReadStream = fileSys.OpenTextFile(codeFile,1, False)

fileString = fReadStream.ReadAll()

' add the new code object to the project

Set codeObj = prjObject.CodeCollection.Add

' Set the server and text for the code

codeObj.Server = codeServer

codeObj.Text = fileString

codeObj.Run ' Run the code

codeObj.Log.SaveAs logFile ' Save the log filelist

Re: Save SAS list

ballardw — Wed, 14 Jan 2015 17:34:28 GMT

Default for SAS 9.3 and later is to not create listing output so version may be important. And possibly how you call SAS as options such as -Print can affect output locations or even if created. Does the log for these jobs show any info about output?

Re: Save SAS list

Dreamer — Thu, 15 Jan 2015 14:38:51 GMT

Hi ,

I'm using SAS 9.4.

There is one option "Proc Print" but I don't want to modify the SAS code. Because there are a lot of them and also I'm not the developer for most of them.

I can use -print option when I execute a SAS code from command line. But I have some EGP files as well and I don't think I can call them from command line.