Extract Metadata Values not Necessarily using Proc *

[shoin]

Hello all.  Two fold question.

1) To get a status of Metadata backup via script run (using proc metadata is not ideal, since the output is in a sas log and will need to be parsed; correct me if wrong), is it possible? Suggestions?  I am looking for a command line feature that we could use, just like with full backup cmd feature that spits out full backup schedule, listings etc. on a stdout and easily captured.

       1a) Has any one run any PROC code embedded in a script or a third party language?  (Curious)

2) Besides java, has any one tried to integrate any third party language like GO, RUST, Python to get status type information from SAS metadata? I will be interested if anyone has done it and their thought on this idea?

Thank you in advance,

S.

[BrunoMueller]

Have you had a look at the "About the Batch Tools for Metadata Server Administration"?

https://go.documentation.sas.com/?docsetId=bisag&docsetTarget=n1ckujedhp86i6n12r9nfcjprnb6.htm&docse...

This should give you what you want

[shoin]

Hi Bruno, TY for he link sir. Actually the question stemmed form that link 🙂 I wanted to find out that the metadata batch tool, has any one embedded in another software (open source also) like Py, RUST, Ruby, GO etc. I have additional commands that are outside of the metadata status (backup in this case) that I would like to grab. I have looked at docs for SASPy module as well.

I appreciate your time and help!

S

[BrunoMueller]

If you tell us what exactly you want to do, this would help.

[shoin]

Hello sorry that I am replying so late. I was stuck overseas in covid19 lockdown. Which should have been a 3 week trip turned into a long nightmare.

well enough sob story.

So I want to see if I could get the backup, IOM server status and SAS logical Servers status, just like the SAS Metadata Server’s Status is possible with PROC METAOPERATE. I would like to write some script that get me all those statuses.

Thank you in advance,

S

[BrunoMueller · Accepted solution]

Have a look at Proc IOMOPERATE. This procedure allows you to connect to many different types of server and query information.

See also this blog https://blogs.sas.com/content/sasdummy/2016/02/15/using-proc-iomoperate/