topic Re: Metadata detail extraction in Administration and Deployment

Metadata detail extraction

MarkNicholas — Wed, 05 Oct 2016 13:16:28 GMT

Hi All,

Need a help on metadata extraction of SAS Management console.
As we know, in the schedule manager, we have the flows and deployed jobs in each of them.

Now, I am working on migration of data from SAS 9.2 to 9.4. But since migration is done over a long amount of time,we have many updates to the deployed jobs in the old environment.

We might have version updates of exisitng jobs in 9.2, for example, the code which was earlier pointing to /sas/mycode/abc.sas may now point to /sas/mycode/abc_v2.sas

So, I wish to create a report with the flowname, deployed name job, Filename it points to. Then I will generate that reports on both environments and we can compare easily on the updates.

From the front end of Management Console, we can get all those properties from the 'Scheduling details' of the deployed job.

Please can I get somehelp with which macro can be suited for this? I know we have lot of SAS provided macro programs like mdudextr or mdsecds ; I am struggling to find that suits my requirement.

Thank you in advance.

Cheers
Mark

Re: Metadata detail extraction

AhmedAl_Attar — Wed, 05 Oct 2016 13:39:51 GMT

Hi Mark,

Have a look at the SAS 9.x language Interface to Metadata, it has examples on how to extract information from your Metadata server and generating reports.

To get yourself familiar with the hierarchy on how/where data is stored, try executing the metabrowse command in the commandBar of your SAS DMS (Classic SAS) session, the command would display a window for SAS Metadata Server Configuration, once you supply the required info, you would File Explorer window displaying the internal representation of the stored metadata.

Hope this helps,

Ahmed

Re: Metadata detail extraction

anja — Wed, 05 Oct 2016 15:07:24 GMT

Hi,

the job names you could get with the proc metadata IOM call <Type>Job</Type>

An example could be

proc metadata in=
"<GetMetadataObjects>
    <Reposid>$METAREPOSITORY</Reposid>
    <Type>Job</Type>
    <Objects/>
    <NS>SAS</NS>
    <Flags>0</Flags>
    <Options/>
</GetMetadataObjects>" out=outfile;
run;

Please note that this is just an "as is" to provide an example

I am not sure that there is an option which would provide you with all the info you are looking for.

Maybe this gives you a pointer what could be possible: http://support.sas.com/documentation/cdl/en/lrmeta/67971/HTML/default/viewer.htm#p1sx3unuqtoykbn141wrhpcj3n1t.htm

Else, you could address this with TS.

Thanks

Anja

Re: Metadata detail extraction

LinusH — Wed, 05 Oct 2016 15:45:58 GMT

Start programming the metadata interface is imo awkward and seems like a sub optimize operation especially when this is probably not a reoccurring requirement.
How many jobs/flows are we talking about?
I guess that your 9.4 isn't in production, perhaps redo the complete Metadata migration could be an alternative?

Re: Metadata detail extraction

MarkNicholas — Wed, 05 Oct 2016 17:37:24 GMT

I have abt 30 flows and am looking at about 900 deployed jobs in all of them.Yes,9.4 is still not live. We do not want to redo the whole thing again - its too much !. It is because, after we export to 9.4, there is a need to check and realign the timeevent in every flow to that of the new env which takes time.

So, if not a manual process of checking almost every job; I want to come up with a program for this detail which infact can be very useful to check if the latest version of codes are present in both the environments at any point of time. I am trying to find my luck if one of the macros contain the sas file name detail as well somewhere in them. Its just that we need to dig them out.

Re: Metadata detail extraction

acfarrer — Tue, 11 Oct 2016 21:47:49 GMT

Bell Canada had a similar issue presented here: http://support.sas.com/resources/papers/proceedings15/2060-2015.pdf