topic Re: Extract Metadata Values not Necessarily using Proc * in Architecture

Extract Metadata Values not Necessarily using Proc *

shoin — Fri, 26 Jun 2020 10:53:11 GMT

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,

Re: Extract Metadata Values not Necessarily using Proc *

BrunoMueller — Mon, 29 Jun 2020 15:50:23 GMT

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&docsetVersion=9.4&locale=en

This should give you what you want

Re: Extract Metadata Values not Necessarily using Proc *

shoin — Wed, 01 Jul 2020 16:30:34 GMT

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

Re: Extract Metadata Values not Necessarily using Proc *

BrunoMueller — Thu, 02 Jul 2020 08:13:32 GMT

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

Re: Extract Metadata Values not Necessarily using Proc *

shoin — Fri, 22 Jan 2021 23:40:13 GMT

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

Re: Extract Metadata Values not Necessarily using Proc *

BrunoMueller — Sun, 24 Jan 2021 16:49:31 GMT

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/