topic Re: How do I read metadata attributes containing more than 32767 chars? in Administration and Deployment

How do I read metadata attributes containing more than 32767 chars?

CHandberg — Thu, 22 Mar 2018 10:22:55 GMT

Hi All

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?

Kurt_Bremser — Thu, 22 Mar 2018 10:38:39 GMT

SAS character variables are limited to 32767 characters, so no luck there with SAS code.

CHandberg — Thu, 22 Mar 2018 11:55:37 GMT

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.

PaulHomes — Fri, 23 Mar 2018 03:19:35 GMT

You could also consider using proc metadata to get the XML in a file and then process it using other tools/languages.

CHandberg — Wed, 04 Apr 2018 11:30:45 GMT

Hi Paul

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!