topic Passing macro values to a stored process in EG in SAS Enterprise Guide

Passing macro values to a stored process in EG

nrose — Wed, 04 Jan 2012 22:39:43 GMT

Hi,

Is it possible to pass macro variable values that are present during a SAS Enterprise Guide session to a stored process that is run in that session? In other words, I don’t want to pass parameters manually into a stored process using prompts, but automatically using macro variables that exist within the SAS EG session from which it is run by the user?

Thanks,

Nick

Passing macro values to a stored process in EG

Patrick — Thu, 05 Jan 2012 01:09:53 GMT

Couldn't you just set up hidden prompts and then use the macro variables as parameter values?

Passing macro values to a stored process in EG

nrose — Thu, 05 Jan 2012 06:06:38 GMT

Thanks Patrick,

I have tried that, but it appears that when you run a stored process, it spawns a new SAS session, which is seperate from the SAS EG session from which it is run. Therefore, macro variables within the SAS EG session are not passed to the stored process.

Therefore, my impression is that there is no way to automatically pass macro variable or other values from a SAS session to a stored process unless entered by a user from a prompt or, unless proc STP is used from a SAS program, which doesn't really solve my problem. Is this correct, or am I missing something?

Nick

Passing macro values to a stored process in EG

Patrick — Fri, 06 Jan 2012 01:10:58 GMT

I believe you are correct.

What you could try to do is to create a text file or a SAS dataset with these key/value pairs (eg. as part of an autoexec) which is also accessible via the stored process server - and then use these information in your code.