I don;t know which version of SAS you have installed, but in any case, there are many options for you:
- you can create your own code with the SAS interfaces to Metadata
- you can use pre-built tools as the Metacoda ( @MichelleHomes ) and get many other great additions.
- You can use the APM/ACM reports which can give you a good inventory of your metadata :
Thanks Juan for mentioning Metacoda Plug-ins.
I might also add that the Metacoda ACT Reviewer is one of the plug-ins that is available free-of-charge. As well as interactively showing the objects to which ACTs are applied it can also be used to export an HTML report as documentation for ACTs - how they are defined, where they have been applied, and how they have been protected.
Yoy can use the following code that will gives you where ACTs are applied :
data ACT (keep=id name PublicType location _created _modified );
length id $20 name PublicType $70 _uri $256 _modified _created $25 location _location $256;
length created modified 8;
format created modified datetime.;
call missing(id, _uri, name, _modified, _created, _location, PublicType);
do while(_n le _nobj);
_nobj=metadata_getnobj("omsobj:AccessControlTemplate?@Id contains '.'",_n,_uri);
do while (_tree>0);
if _tree > 0 then do;
location = '/'||location;
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.