03-22-2018 06:22 AM
I need to read the 'DefaultValue'-attribute from the DiagramXml-property. (XML that control the formatting of the job in DI Studio)
Unfortunately the content of the attribute is more than 32767 chraracters long so i'm not able to read the full content.
spnrc = metadata_getattr(spuri,'DefaultValue',Jobxml);
Is there a way to read more than 32767 chars into a sas variable, use char functions on it and write it back?
03-22-2018 06:38 AM
SAS character variables are limited to 32767 characters, so no luck there with SAS code.
Consider using the Java Metadata Interface.
03-22-2018 07:55 AM
I was affraid that this was the answer. Even the Metabrowser in DisplayManager are not able to display the value, so I think SAS has a little issue :-)
Thanks for the fast reply and thank you for the reference to the Java Metadata Interface.
03-22-2018 11:19 PM
You could also consider using proc metadata to get the XML in a file and then process it using other tools/languages.
04-04-2018 07:30 AM
I'll definitely try that as a solution.
Until now I've been able to just use the Datastep Metadata Functions, but it seems that I have to explore the possibilities in using Proc Metadata.
Thank you for the answer!