how to get deleted datasets names information in temparory library and permenant library

[BrahmanandaRao]

Hi Guys ,

Good Morning 

How to get deleted datasets names information in temp library and permanent library ?

[LinusH]

SAS datasets and other SAS files are files. When deleted they're gone.

So I need a bit more context. What is your situation/requirement/use case?

[BrahmanandaRao]

i want to know which datasets have been deleted that information 

[LinusH]

It all depends on your system configuration.

If you allow SAS server access only to SAS datasets, you could find this information in SAS server logs, given that you activate appropriate logging levels.

More realistic is probably to investigate if the OS that hold the data can be configured with logging of file operations.

If your requirement is keep track on such operations I think moving your data to a RDBMS is one way to solve it.

[Oligolas]

Hi,

If you're looking for metadata, take a look at the dictionary tables

The information of which datasets are known to SAS at run time can be found in sashelp.vtable.

If you save the states before and after your operations in two datasets you could compare them afterwards:

data stateBefore;
   set sashelp.vtable;
run;

*[...Some operations...];

data stateAfter;
   set sashelp.vtable;
run;

proc compare base=state comp=stateAfter listall; run;

PS: sashelp.vcolumn lists the variables as well and could be of interest for you