0

I have a production environment server using SAS Platform. Is there a way to generate a report of a list of all metadata objects deployed in this production environment?

More accurately, is there an easy point-and-click way using one of the SAS Tools (e.g. SAS EG, SAS DI, SAS SMC)? If not I am open to the "right" way of doing it.

Allan Bowe
  • 12,306
  • 19
  • 75
  • 124
barney
  • 141
  • 1
  • 2
  • 6
  • Yes, there is, using SAS Open Metadata Interface, however it would be better if you were more specific about the type objects you wish to report on. For example, Users, Tables, Libraries? – mjsqu Nov 30 '14 at 00:44
  • I think I need two kinds of reports, 1) one on all the metadata objects (which can include Users, Libraries, ACTs, Tables, etc) deployed on a system 2) one on just the metadata objects in the SAS Metadata (exclude Users, ACTs, etc) – barney Dec 01 '14 at 04:48
  • You could export a package from DI Studio containing everything in the SAS Metadata Repository, but it may take a while to analyse all of the connections between elements. Alternatively I think there's a way to get this information from SAS Management Console, but I can't confirm as I don't have either application to hand. – mjsqu Dec 01 '14 at 13:56

2 Answers2

1

you can try using the %MDSECDS macro which is shipped whit SAS/Foundation. This macro provide a lot of informations like you are looking for.

Paxi
  • 61
  • 4
0

If you are looking to extract a list of all the objects that can be seen in the folder tree, this macro from the macrocore library will do it:

 %mm_tree(outds=allmyobjects)

Note - if you have multiple repositories, you will need to run this for each (and set options metarepository=YOURREPO; each time).

A macro to get the list of repos is available here.

Allan Bowe
  • 12,306
  • 19
  • 75
  • 124