Hi, Pass and fail information is extracting every day from source system table called X to table A Now Table A has 10+ years (increasing day by day) history (result variable has pass and fail info) so 1) I want to delete all the fail information and keep pass information all the time from Table A and want to keep only 6 months information of fails in table A every time.(pass info all the time and fails only for 6 months in table A) data a B;
set A;
if Result="F" then output b ;
else if Result="F" and dt>=intnx('month',today(),-6,'s')then output a ; I think I am missing Pass information here. 2) And save all deleted fail information in table B and I want to keep only 4 years of fail information all the time in table B. logic is not correct ,I think data B;
set b;
if Result="F" and dt>=intnx('year',today(),-4,'s');
run; This process should be automated every day. Thanks, SS
... View more
