Desktop productivity for business analysts and programmers

Passing macro values to a stored process in EG

Reply
Frequent Contributor
Posts: 91

Passing macro values to a stored process in EG

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

Respected Advisor
Posts: 3,840

Passing macro values to a stored process in EG

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

Frequent Contributor
Posts: 91

Passing macro values to a stored process in EG

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

Respected Advisor
Posts: 3,840

Passing macro values to a stored process in EG

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.

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