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
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
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.
Ready to level-up your skills? Choose your own adventure.