topic Re: Automating SAS using VBScript - Exporting output of SAS Data Set in SAS Enterprise Guide

Automating SAS using VBScript - Exporting output of SAS Data Set

Ejaz — Thu, 18 Apr 2019 01:38:35 GMT

In my process flow in SAS EG, I am importing a CSV --> Filter the data through Query Builder --> Output in SAS Data Set

My agenda is to run it through .vbs as per mentioned in the post

https://communities.sas.com/t5/SAS-Communities-Library/Doing-More-with-SAS-Enterprise-Guide-Automation/ta-p/417832

After running it, I want to export data in SAS Data Set to my destination folder (without using a program)

The example in above post do not execute/run the process flow and export the output in the folder.

Any helps please?

One more thing, can I run SAS EG process flow through CLI in Windows?

Re: Automating SAS using VBScript - Exporting output of SAS Data Set

ChrisHemedinger — Thu, 18 Apr 2019 19:32:12 GMT

Adapting the BatchProject.vbs example, you should be able to do something like:

For n=0 to (sasProgram.OutputDatasets.Count -1)
  Dim dataName
  dataName = sasProgram.OutputDatasets.Item(n).Name
  sasProgram.OutputDatasets.Item(n).SaveAs _
    getCurrentDirectory & "\" & dataName & ".sas7bdat"
Next

And using script, you can also run individual process flows -- by name. See how to address Flows in the ExtractCode.vbs example.

Re: Automating SAS using VBScript - Exporting output of SAS Data Set

Ejaz — Wed, 24 Apr 2019 09:21:31 GMT

Thanks for your kind reply,

I don't know how to open my existing sasProgram as per your code. How can I load my .egp file and than set the variable sasProgram?

For n=0 to (sasProgram.OutputDatasets.Count -1)

Let me provide some details about my requirement in steps

Requirement: To execute an existing process flow and save its output through automation script

Steps to follow

1- Open .egp file

2- Click on Run Process Flow

a) Loads data from CSV (Import Data) and create DataSet

b) Perform one or more transformation on DataSet and generate result/final DataSet

3- Save the output tables data result/final (Sas Dataset) via export (or anything) on the disc

The program you are referring to, I have reviewed them. The BatchProject.vbs example does not open a project/sasProject

And, ExtractCode.vbs example does not execute the processflow and does not save the output of executed process flow.

Kindly help