Hi Learnerea, Really appreciating your videos and efforts... Have even commented on one of earlier video. can you pls help me with function such as rollback or anything that can reverse the submitted command. Actually i mistakenly append few details twice - i know here nodupkey can help but what if we mistakenly end up deleting any records/dataset ... then how to reverse that action ??
Thank you for watching and commenting on the videos Inrajeet. sorry to disappoint you, as far as I'm aware of, there isn't any command which will undo your work... but that's something which can be worked out... One of the solution you already have... which removing the duplicates... so if you let us know particularly what sort of actions you would like to undo... will be able to suggest some work around.. if it's duplicate thing... I would suggest instead of using proc append, use set statement, that will prevent the duplicates no matter how many times you repeate the same submit..
to find the opposite lag, just sort the data in descending order and find the lag (this is called lead)... if this doesn't solves your issue, try putting your problem statement with example, that will help us provide you the specific solution
everything will remain same, just have the data sorted basis on your date column and wherever I have considered six you make that seven... it's gonna be simple, all the best
Hi Learnerea, Really appreciating your videos and efforts... Have even commented on one of earlier video.
can you pls help me with function such as rollback or anything that can reverse the submitted command.
Actually i mistakenly append few details twice - i know here nodupkey can help but what if we mistakenly end up deleting any records/dataset ... then how to reverse that action ??
Thank you for watching and commenting on the videos Inrajeet.
sorry to disappoint you, as far as I'm aware of, there isn't any command which will undo your work... but that's something which can be worked out...
One of the solution you already have... which removing the duplicates...
so if you let us know particularly what sort of actions you would like to undo... will be able to suggest some work around..
if it's duplicate thing... I would suggest instead of using proc append, use set statement, that will prevent the duplicates no matter how many times you repeate the same submit..
Hi
Thanks for reply
I have a doubt if I want to calculate last 31 days rolling sum how I can do it.
Please help.
Did you try the method explained in this video, what is the error or problem that you are getting into that
How can we do opposite of lag and find the ratio of alternative transaction and then if ratio
to find the opposite lag, just sort the data in descending order and find the lag (this is called lead)...
if this doesn't solves your issue, try putting your problem statement with example, that will help us provide you the specific solution
If we want to calculate last 7 days Average.
How we can achieve that ?
everything will remain same, just have the data sorted basis on your date column and wherever I have considered six you make that seven...
it's gonna be simple, all the best