topic Re: sort a data set while preserving the audit trail in SAS Programming

sort a data set while preserving the audit trail

Sasuser52 — Wed, 20 May 2020 16:46:24 GMT

Dear SAS-Community,

is there a way to sort a data set and preserve the audit trail?

Proc Sort replaces the data set and does not preserve the audit trail.

Thank you!

Re: sort a data set while preserving the audit trail

s_lassen — Wed, 20 May 2020 19:37:54 GMT

I do not think there is. But you could try putting an index on the table instead, e.g.:

/* This does not work. Audit trail will be dropped:
proc sort data=audited;
  by ID Date;
run;
*/

proc sql;
  create index idx on audited(ID,Date);
quit;

You should then be able to read the data set BY ID DATE. It may run more slowly, but if the table is not too big, that should not be a problem.

PS: Not tested, just a suggestion to try.

Re: sort a data set while preserving the audit trail

Sasuser52 — Thu, 21 May 2020 13:06:17 GMT

Thank you for your answer 🍓. Your answer might help somebody, but for me this is not what I am looking for.