topic How can I obtain SAS DDS Logs? in Administration and Deployment

How can I obtain SAS DDS Logs?

JM7 — Tue, 19 Apr 2022 15:29:50 GMT

Hi Everyone,

I'm investigating possible deletions in my DDS, do you know if exist any logs that contain the applied changes in a DDS?

Thank you in advance!

Re: How can I obtain SAS DDS Logs?

sbxkoenk — Tue, 19 Apr 2022 18:10:12 GMT

Hello,

This is very cryptic.

Are you referring to the SAS® Detail Data Store?
If yes, which one? The one for insurance?

Thanks,

Koen

Re: How can I obtain SAS DDS Logs?

LinusH — Wed, 20 Apr 2022 12:59:26 GMT

If your data store i Base SAS, (without audit enabled - which is by far the most common), you have to resort to various SAS logs on you compute server.

For batch updates check under the BatchServer directory in your configuration.

Interactive SAS sessions use WorkspaceServer, but the default setting is not to keep logs stored on the server.

Re: How can I obtain SAS DDS Logs?

AllanBowe — Thu, 21 Apr 2022 11:53:21 GMT

If you would like to capture full change details of your ETL loads you could consider this macro: https://core.sasjs.io/mp__storediffs_8sas.html

It could result in a very big audit table though, for a typical DDS ETL batch run.

Here is an example of tracking deletes using Data Controller:

(view in My Videos)

Re: How can I obtain SAS DDS Logs?

Patrick — Thu, 21 Apr 2022 12:08:17 GMT

Assuming DDS stands for SAS Detailed Data Store then it depends how/where it's installed. If it's SAS tables then the only place where you could find any information about deletions are SAS logs. If "deletion" has been done properly then at least for SCD2 type tables there wouldn't be an actual deletion but just an expiration of a row and these you could identify in the table.

If the DDS has been installed on a database then there might be some DB logging turned on that keeps track of deletions. You would need to talk to a DBA to figure out what logging level has been turned on and how to access this log information.