Desktop productivity for business analysts and programmers

Outputting SAS EG Prompt metadata

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

Outputting SAS EG Prompt metadata

Hello,

 

I am not sure if this is possible.  I am writing procedures on a project I created in EG and I would like to output the metadata of all the prompts.  I would need things like the Prompt name, default value, displayed test, description, etc...  I have easily gotten the prompt name and default value by

  1. Creating a blank program
  2. Adding all of my EG prompts to it via the properties
  3. Running the blank program
  4. Copying the part of the log that contains the %let statements for the prompt default values

Is there a similar way to get things like the description, displayed text, prompt type, ect...?


Accepted Solutions
Solution
‎04-20-2018 10:51 AM
Community Manager
Posts: 3,348

Re: Outputting SAS EG Prompt metadata

Posted in reply to andreas_lds

You can obtain at least some of this via EG Automation.  See this article about automation in VBScript and PowerShell.

 

A prompt/param snippet for VBscript:

 

' 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

View solution in original post


All Replies
Super Contributor
Posts: 498

Re: Outputting SAS EG Prompt metadata

[ Edited ]
Posted in reply to hulksmash

Afaik there is no way to get the metadata, when the egp is loaded.

 

You could unzip the egp and extract the data from project.xml, there is a tag called <Parameters> containing the complete definition of all prompts.

Solution
‎04-20-2018 10:51 AM
Community Manager
Posts: 3,348

Re: Outputting SAS EG Prompt metadata

Posted in reply to andreas_lds

You can obtain at least some of this via EG Automation.  See this article about automation in VBScript and PowerShell.

 

A prompt/param snippet for VBscript&colon;

 

' 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
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 100 views
  • 0 likes
  • 3 in conversation