sort a data set while preserving the audit trail

[Sasuser52]

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!

[s_lassen]

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.

[Sasuser52]

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