topic Re: pass a parameter to SAS EG project. in SAS Enterprise Guide

pass a parameter to SAS EG project.

deleted_user — Fri, 27 Feb 2009 09:05:41 GMT

Hi friends,
I have schedule a SAS EG project . It created a EGScript.vbs file for me to run the project.
I want to know that how can i pass a parameter (eg. say a path of a input file which will be required somewhere in project code). I need to give this EGScript.vbs file to a guy who just need to change the path as per his requirement.
can someone help.
Thank You

Re: pass a parameter to SAS EG project.

deleted_user — Mon, 02 Mar 2009 07:15:14 GMT

hey ...if any body knows..... then plssssssss let me know...
tell me if there is some other way of doing it.... Message was edited by: Avi

Re: pass a parameter to SAS EG project.

sbb — Mon, 02 Mar 2009 17:12:03 GMT

When launching SAS, it is possible to pass a SYSPARM= parameter -- I suggest you explore how you can introduce this parameter into your vbs script as a command invocation parameter, then your SAS program can reference either the automatic macro variable named &SYSPARM, or you can retrieve the SYSPARM= character string using the SYSPARM() function.

The SAS DOC has information about SYSPARM.

Scott Barry
SBBWorks, Inc.

Re: pass a parameter to SAS EG project.

RichardH_sas — Tue, 03 Mar 2009 14:13:07 GMT

Hi Avi,

I haven't done much with scheduling, but my guess is you're probably going to need to use a %LET statement to assign the path value. Anyone with better ideas please jump in!

So, if the parameter name is PATH1, I would create a Code Node at the top of your project with the code:

%LET path1=c:\whatever;

The person you're giving the project to will have to modify this code by hand to the appropriate path. Verify in the code/task that's using the path that there are double quotes to get the macro variable to resolve correctly.

RIGHT: "&path1\textfile.dat"
WRONG: '&path1\textfile.dat'

To be on the safe side, once you have the %LET in the project I'd then delete the parameter from the parameters manager. My guess is that EG would just sit there waiting for the user to type the parameter value if one is still in the project, but again, haven't tried this. Before you delete the parameter from the Parameters Manager, make sure you have a backup of the project in case my instructions are totally off-base!!

Hope this helps.

Re: pass a parameter to SAS EG project.

deleted_user — Tue, 03 Mar 2009 15:06:11 GMT

Hi
Thank you for the replies.
I tried giving some code in the EGscript.vbs like

project.run
project.submit("%let Mpath =%str(D:\SAS\InputFiles);")

This statement creates a Macro variable Mpath which can be resovled any where in project. this macro may be SYSparam also. but
which i hoped it will run as the first code in the project. But it not seems to be working. this code never runs ..... i checked logs
see the guy to which has nothing to do with sas ...My project creates few report based on a input file. the problem is the path to input file cannot be fixed... i have to give the only vbs script to him , and running the script runs the project on server .. and stores the o/p in a folder. so he needs to only modify the path when required in vbs script.

Re: pass a parameter to SAS EG project.

RichardH_sas — Tue, 03 Mar 2009 21:27:48 GMT

Avi,

Are you using the path to point to raw data files (aka flat files), or SAS data sets, or something else entirely? I've got some ideas but wanted to ask that up front.

Re: pass a parameter to SAS EG project.

deleted_user — Wed, 04 Mar 2009 04:40:46 GMT

ya , i am using the path to point a rawdata file which is a CSV file.

Re: pass a parameter to SAS EG project.

sbb — Wed, 04 Mar 2009 18:52:25 GMT

The presumption here is that you need the variable data in your SAS environment. So, you need to determine how/where SAS is being invoked and introduce a SAS run-time CONFIG parameter override, either using SYSPARM= or you can use the IS= (short for INITSTMT= ) where you can supply directly your %LET statement. If you choose SYSPARM, then you can access the string using the SAS automatic variable &SYSPARM, or by using the SAS function SYSPARM() to assign a DATA step variable, as needed, in your application program.

Scott Barry
SBBWorks, Inc.

Re: pass a parameter to SAS EG project.

RichardH_sas — Wed, 04 Mar 2009 20:07:25 GMT

I think you may be trying to do too much in the VB script and not enough in the project itself. I'm looking at a sample VB script that EG generated for scheduling, and I don't see anything in there that would allow you to set a value for a path. The relevant VB code seems to be:

' Start up Enterprise Guide using the project name
'----
Dim prjName
Dim prjObject

prjName = "C:\workshop\winsas\egqr4\DemoData\Demo.egp" 'Project Name

Set app = CreateObject("SASEGObjectModel.Application.4")
If Checkerror("CreateObject") = True Then
Exit Sub
End If

'-----
' open the project
'-----
Set prjObject = app.Open(prjName,"")
If Checkerror("app.Open") = True Then
Exit Sub
End If

You could explore whether using SYSPARM would allow you to supply the path to EG, as Scott suggests. I don't have much experience with that, but know SYSPARM is designed for situations like this.

Me personally, I would modify the part of the project that's reading the CSV file. Take the code generated by the import data task, copy it, and paste it into a new code node. Add a %let at the top of that code to store the path. Reference that macro variable on the infile statement (as previously posted). Lastly, get rid of the original import data task and any stuff in the parameters manager since the code node is going to handle that part. The end user will have to change the code in the project to meet their needs -- so you'll need to share the project AND the VB script. This may be what you were hoping to avoid... but this is the way I know how to do it. If you get desperate, remember you can say File > Export > Export All Code. This has it's own problems, but it's a good technique to know about.

So, hope you can get this working! I'm sorry I can't be more help on the VB stuff; I get lost once I start venturing outside SAS. 🙂

Re: pass a parameter to SAS EG project.

ChrisHemedinger — Thu, 05 Mar 2009 12:51:23 GMT

The EG automation model allows you to access and set values for project parameters -- those parameters that you've defined with the Tools->Parameter Manager.

Here is an example VB script that works with parameters that you've defined in your project.

[pre]
Option Explicit
Dim app
Dim prjName
Dim prjObject
Dim parmList
Dim parm

prjName = "C:\temp\autowithparams.egp" 'Project Name

' start the app and open the project
Set app = CreateObject("SASEGObjectModel.Application.4")
Set prjObject = app.Open(prjName,"")

' discover the parameters
Set parmList = prjObject.Parameters
Wscript.Echo "Project has " & parmList.Count & " parameters."

' work with the first parameter
Set parm = parmList.Item(0)
WScript.Echo parm.Name & " parameter has default value of " & parm.DefaultValue
parm.Value = "M"

WScript.Echo parm.Name & " parameter has been set to value of " & parm.Value

' run the project
prjObject.Run

WScript.Echo parm.Name & " parameter has been set after Run to value of " & parm.Value

prjObject.Close
app.Quit
[/pre]

Chris

Re: pass a parameter to SAS EG project.

RichardH_sas — Fri, 06 Mar 2009 21:52:30 GMT

Chris' answer was definitely better than mine. 🙂 Use that!

Re: pass a parameter to SAS EG project.

deleted_user — Mon, 09 Mar 2009 07:16:37 GMT

hey Chris,

I will definitely try this.
I had previously tried written below,but some thing went wrong.

prjObject.code mycode = prjObject.codeCollection.add;
mycode = "%Let mypath=%str(D:\SAS\INputfiles)"
mycode.run

i will let you know the results ..thanks.

regards
Avi

Re: pass a parameter to SAS EG project.

deleted_user — Mon, 09 Mar 2009 10:10:50 GMT

Hi chris ...

Thank you very much . The solution you gave was perfect. It worked fine.

Avi

Re: pass a parameter to SAS EG project.

DF — Mon, 10 Aug 2009 11:20:21 GMT

@Chris,

The code example you provided allows for a parameter's value to be set using its numerical index, but is there a method that allows it to be set by name?

The only method I've found, which seems a strange approach, is to parse the list of parameters until I match the required name and then set the value. This doesn't seem like the best approach, but I've been unable to find any other way to access a specific parameter.

Re: pass a parameter to SAS EG project.

ChrisHemedinger — Tue, 11 Aug 2009 14:12:33 GMT

DF,

No, I don't think there is a better approach right now when using VBScript to automate it. I admit it's a bit klunky...

Chris

Re: pass a parameter to SAS EG project.

DF — Tue, 11 Aug 2009 14:27:08 GMT

Thanks for clarifying that Chris - I can stop looking now!

pass a parameter to SAS EG project.

nrabonik — Sat, 24 Dec 2011 03:27:15 GMT

Chris -

I am trying to pass a parameter from a vbs/wsf code into a SAS Project. I am using your approach but am not having success. (I am using EG 4.3, which points to a SAS Server running 9.2). In essence, while it looks like the vbs object gets the correct variable values set, (and even indicates that the default values for each parameter are correctly set and extracted), the parameter values do not seem to exist when the SAS project starts to execute. Sorry in advance for writing so much.

1. in my sas project, i have added three variables using the Prompt Manager window. They are filepath, lastmoddate, lastmodtime.

2. in my vbs code, i have

a)the code:

=========

' Declare SAS object/Variables

Dim oSASApp

Dim oSASProj

Dim oParmCollection

Dim oParm

dim sSasP ' Path to SAS code

dim sSasF ' Filename of SAS code

dim filepath

dim moddate

dim modtime

sSasF = "*****************\shell_of_ice.egp" 'Does not end w/.egp

moddate = "09/09/9999"

modtime = "09:09:09"

WScript.Echo moddate & " " & modtime

' start the sas app and open the project

Set oSASApp = CreateObject("SASEGObjectModel.Application.4.3")

WScript.Echo "sasapp setup"

Set oSASProj = oSASApp.Open(sSasF,"")

WScript.Echo "I have setup sas proj."

' Discover parameters Within the opened SAS project which are already defined.

Set oParmCollection = oSASProj.Parameters

' pass values to those parameters

dim p

for p = 0 to oParmCollection.Count - 1

Set oParm = oParmCollection.Item(p)

WScript.Echo oParm.Name & " parameter has default value of " & oParm.DefaultValue

if oParm.Name = "lastmoddate" then

oParm.Value = moddate

elseIf oParm.Name = "lastmodtime" then

oParm.Value = modtime

else 'filepath

oParm.Value = filepath

end if

next 'p

' run the project

msgbox "about to run project"

oSASProj.Run

msgbox "ran project"

b)the output from vbs:

==================

I have setup sas proj.

filepath parameter has default value of **************\poweractivity_2011_12_22.csv

lastmoddate parameter has default value of 01/01/01

lastmodtime parameter has default value of 01:01:01

3. below is the log from the SAS project executing - please note, i have used %put statements at the beginning of my SAS Program and also at the end. I am getting the following errors:

16 %put &filepath;

WARNING: Apparent symbolic reference FILEPATH not resolved.

&filepath

17 %put &lastmoddate;

WARNING: Apparent symbolic reference LASTMODDATE not resolved.

&lastmoddate

18 %put &lastmodtime;

WARNING: Apparent symbolic reference LASTMODTIME not resolved.

&lastmodtime

Many thanks,

pass a parameter to SAS EG project.

nrabonik — Sat, 24 Dec 2011 03:53:59 GMT

ok i resolved the issue!! and will leave the post up in case it will be of help to others.

while i already defined the different parameters, i did not attach them to a particular program in the project. to do this, right click the program in the Process Flow view, and select Properties, and then Prompts. Then, one by one, associate each prompt parameter to the desired program.

Steep learning curve, for sure.