Hello all,
Please can you answer couple of below Questions I have.
Question 1
can any one tell me how to find out a Oracle (or) Base library when it was created and on which user request it was created and by Whom it was created.
Is there a way to find out above details from SAS Mananement console 9.2 (or) Is there any sas code that give details submitting from EG.
Question 2
and also I want to find out what is the Metadatacreated date for the tables in a Library from sas management console(SMC)
Is this the date the tables registered date in that library in SMC or someother date
the tables in the Library in SMC when I checked the properties-->Advanced
It shows as below when I checked the properties-->Advanced
Attributes
Name Value
Metadatacreated Apr 12,2014 1:30:22 PM
Would really appreciate for your valuable suggestions,please help me
Thanks you all in advance
Hi
Not an answer to all questions:
A simple way to get back the created and modified date for an Metadata object is to use the %MDSECDS macro, below is an example.
%mdsecds(
membertypes="Library"
, perms="ReadMetadata"
, identitynames="sasdemo"
, identitytypes="Person"
)
You can use the SAS® 9.4 Language Interfaces to Metadata to access anything within the Metadata Server.
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.