BookmarkSubscribeRSS Feed
max7
Fluorite | Level 6

Hi All,

 

I need to report all the prompts(including shared prompts) infomation associated with all the stored processes. If the prompt refers any table column, the report should also include the table name & the corrosponding column name. Tried using the proc metadata procedure and able to get the details (including Groupinfo property) in the xml file format. The required information is present in the 'Groupinfo' attribute. However I am unable to decode the xml-coded text completely as some of my 'Groupinfo' property contains values greater than 32767 bytes length. Also I am unable to search through the 'Groupinfo' using SXLE maps as I could not find any options to search through & filter the attributes which contain larger values within xml tags (for e.g. the Groupinfo attribute)

 

When I use the metadata datastep functions, the 'Groupinfo' values are truncated & information is lost as the sas datastep only supports 32767b character length,

 

Is there any options in XML mapping/metadata data step functions which accomadates mapping & search through longer attribute values(>32767). OR any other Solutions?

 

It would be great if you help me to find the all prompts info associated with stored process through code. Thanking you in advance.

 

Regards,

Max

1 REPLY 1
tomrvincent
Rhodochrosite | Level 12
Have you tried examining the source code of them instead?

SAS INNOVATE 2024

innovate-wordmarks-white-horiz.png

SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg

 

 

Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 306 views
  • 0 likes
  • 2 in conversation