topic Re: files and folders : delete , creation, modification in SAS Programming

files and folders : delete , creation, modification

LineMoon — Tue, 30 Jun 2015 21:23:36 GMT

Hello,

Is it possible to see in sas the history of deleting (and creation) a files or folder by with user.

I am talking about externel and internal files(=sas file)

If not, I am open to others solutions( unix,....)

Thank you

Re: files and folders : delete , creation, modification

arodriguez — Wed, 01 Jul 2015 06:01:46 GMT

For external files I don't know, but for internal files, you have the dataset SASHELP.VTABLE.

In this table appear the library, the name of the table and when was editted and created.

Re: files and folders : delete , creation, modification

Kurt_Bremser — Wed, 01 Jul 2015 06:37:54 GMT

This may need the auditing subsystem of your operating system.

Caveats:

will use CPU resources, and will need lots of space for the audit logs, depending on the traffic in the audited resources.

Re: files and folders : delete , creation, modification

LineMoon — Wed, 01 Jul 2015 21:26:22 GMT

Thank you.

I am intersted by files was deleting

Re: files and folders : delete , creation, modification

Kurt_Bremser — Thu, 02 Jul 2015 07:20:51 GMT

Once a file is deleted, all traces of it are gone in SAS, as the dictionary tables are created "live" from the currently assigned libraries.

To detect the deletion of a file, one needs to audit the directory where the file is(was) stored, because deletion involves writing to the directory.

Re: files and folders : delete , creation, modification

RW9 — Thu, 02 Jul 2015 09:04:46 GMT

As KurtBremser has stated, this would be in your OS. However there is also another alternative. If you have a version control system setup (and why would you not if your programming), and the files in question are versioned through that, then you can check the history of the file via the svn repository which will give you an XML report on actions, changes, when, by who etc.

Re: files and folders : delete , creation, modification

LineMoon — Thu, 02 Jul 2015 21:24:18 GMT

Thank you

But I do not have svn