Architecting, installing and maintaining your SAS environment

Metadata detail extraction

Reply
Contributor
Posts: 31

Metadata detail extraction

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

 

Regular Contributor
Posts: 216

Re: Metadata detail extraction

Posted in reply to MarkNicholas

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

SAS Super FREQ
Posts: 299

Re: Metadata detail extraction

Posted in reply to MarkNicholas

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#p1sx3unuqtoykbn141w...

 

Else, you could address this with TS.

 

Thanks

Anja 

 

Super User
Posts: 5,427

Re: Metadata detail extraction

Posted in reply to MarkNicholas
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?
Data never sleeps
Contributor
Posts: 31

Re: Metadata detail extraction

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.

Contributor
Posts: 27

Re: Metadata detail extraction

Posted in reply to MarkNicholas

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

 

 

Ask a Question
Discussion stats
  • 5 replies
  • 538 views
  • 1 like
  • 5 in conversation