Desktop productivity for business analysts and programmers

Ways to find out a Library created Date from SMC or EG.

Reply
Regular Contributor
Posts: 151

Ways to find out a Library created Date from SMC or EG.

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

 

 

SAS Super FREQ
Posts: 703

Re: Ways to find out a Library created Date from SMC or EG.

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.

 

 

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 214 views
  • 0 likes
  • 2 in conversation