About Author

Gerry Nelson

Principal Technical Consultant

Gerry Nelson is a Principal Technical Architect in the Global Enablement and Learning (GEL) Team within SAS R&D's Global Technical Enablement Division. His primary focus is on administration of SAS environments, particularly migration, promotion and upgrading.

4 Comments

    • Gerry Nelson
      Gerry Nelson on

      Hi Raj,

      in SAS 9.2 you can use used programming interfaces to metadata such as the metadata data step functions or PROC metadata to develop SAS programs which create these reports as referenced above.

      An easier approach is using one of the "Security Reporting Macros". They are documented in the Security Administration Guide. A call to the MDSECGO macro will return all metadata content to a SAS dataset. For example:

      %mdsecgo(folder="/",
      includesubfolders=YES,
      memberfilter="",
      objdata=my_objects);

      Similarly for users and groups you can use %MDUEXTR macro documented in the appendix of the Security Administration guide.

        • Gerry Nelson
          Gerry Nelson on

          You don't absolutely have to run it as the administrator, but I would recommend that you do. That is the best way to guarantee that you get all the metadata in your report. If you run as a different users you may only see the items that they have readmetadata access to.

Leave A Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back to Top