topic Re: Undo the changes in table through proc sql in SAS Enterprise Guide

Undo the changes in table through proc sql

Riteshdell — Wed, 15 Jun 2016 09:30:49 GMT

Hello All,

Its very Urgent. I need your valuable help.

I have a Data set. and it consist of 3500 Rows, Wrongly I have updated some thing else.

I was updaing for 2-3 rows, but it got updated for all 3500 rows. and i don't have back up too.

Please help me to do undo changes if possible through.

I was doing updation, through proc sql;

update table_name;

Please help me , if it is possible to undo the changes in table.

Thanks ,

Ritesh

Re: Undo the changes in table through proc sql

RW9 — Wed, 15 Jun 2016 09:55:07 GMT

Well, SAS isn't a database so it doesn't have rollback functionality or audit trail. I am not familiar with EG any more, does that have audit history in it, didn't last time I looked. If its data on a server then the likelihood is that your IT group willl mirror the data each night - if you contact them and them to restore the file to the way it was the day or timepoint before you made a change then you should be able to get it back, can't think of a simpler way. Take it as a tip for the future - never modify source data - extract source data to working data and manipulate that.

Re: Undo the changes in table through proc sql

Kurt_Bremser — Wed, 15 Jun 2016 10:46:30 GMT

Have the last backup restored. If you don't have a backup, you need to rerun the original creation path of the dataset.

ALWAYS have a backup of production data, and ALWAYS keep your programs (including previous versions) so you can recreate data if you have to step back.

If you don't have a backup, you just received one of the most important lessions in data processing.

Re: Undo the changes in table through proc sql

Riteshdell — Wed, 15 Jun 2016 10:49:49 GMT

Thanks @kurtbremser- I understood, next time i will always take a backup..