06-15-2016 05:30 AM
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;
Please help me , if it is possible to undo the changes in table.
06-15-2016 05:55 AM
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.
06-15-2016 06:46 AM
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.