Do you have an example/code for reading alle changes for all objects in metadata?? I would like to have all informations , whats has been changes , when og by who? Is it possible on SAS 9.4 M& out of the box and with SAS code? I know there is build-in macros as %MDUEXTR and %mdsecds and the following snippet (se below) but I want more variables eg. user, timestamp etc. data All_Metadata_Object_types (keep=id name PublicType ApplicablePermissions desc); length id $20 name PublicType $70 _uri ApplicablePermissions desc $256 ; _nobj=1; _n=1; call missing(id, _uri, name, PublicType, ApplicablePermissions ,desc); do while(_n le _nobj); _nobj=metadata_getnobj(“omsobj:TypeDefinition?@Id contains ‘.'”,_n,_uri); _rc=metadata_getattr(_uri,“Id”,id); _rc=metadata_getattr(_uri,“Name”,name); _rc=metadata_getattr(_uri,“PublicType”,PublicType); _rc=metadata_getattr(_uri,“ApplicablePermissions”,ApplicablePermissions); _rc=metadata_getattr(_uri,“Desc”,Desc); output; _n=_n+1; end; run;
... View more