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
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
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
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.
Bell Canada had a similar issue presented here: http://support.sas.com/resources/papers/proceedings15/2060-2015.pdf
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.
Find more tutorials on the SAS Users YouTube channel.