topic Re: Outputting SAS EG Prompt metadata in SAS Enterprise Guide

Outputting SAS EG Prompt metadata

hulksmash — Wed, 18 Apr 2018 14:43:41 GMT

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

Creating a blank program
Adding all of my EG prompts to it via the properties
Running the blank program
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...?

Re: Outputting SAS EG Prompt metadata

andreas_lds — Wed, 18 Apr 2018 15:43:41 GMT

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.

Re: Outputting SAS EG Prompt metadata

ChrisHemedinger — Wed, 18 Apr 2018 16:14:59 GMT

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