generate subsequent restatement

[Yi Zi]

Hello,
Hope you are well.
Just wondering shall I know how to generate the subsequent restatement based on your post? let's say, the materials are misstated in the year 2015, and I would like to see whether it is restated in the following years. In detail, I would like to end the sample period in the fiscal year 2017 to allow three subsequent years for misstatements to be revealed.

* Example generated by -dataex-. For more info, type help dataex
clear
input double(RES_ACCOUNTING RES_FRAUD) long(RES_BEGIN_DATE RES_END_DATE FILE_DATE) str10 COMPANY_FKEY str6 BEST_EDGAR_TICKER
1 0 20148 20239 20284 "0000001750" "AIR"  
1 0 16802 16982 17125 "0000001853" ""     
1 0 16437 16801 17273 "0000001853" ""     
1 0 17837 17928 17973 "0000001923" ""     
1 0 17653 18658 18744 "0000001923" ""     
1 0 17167 17897 18032 "0000001961" "WDDD" 
1 0 19359 19904 20010 "0000001961" "WDDD" 
1 0 19905 21000 21126 "0000002034" ""     
1 0 21001 21274 21440 "0000002034" ""     
1 0 12600 16801 16866 "0000002135" ""     
1 0 14976 15340 15792 "0000002178" "AE"   
1 0 15341 15705 15839 "0000002178" "AE"   
0 0 16437 16709 16868 "0000002178" "AE"   
1 0 15157 16526 16743 "0000002491" ""     
1 0 15157 16617 16919 "0000002491" ""     
1 0 15522 16617 17079 "0000002491" ""     
1 0 15522 17166 17471 "0000002491" ""     
1 0 17714 17805 18205 "0000002491" ""     
1 0 14610 15340 15432 "0000003116" ""     
1 0 15706 15978 16070 "0000003116" ""     
0 0 16437 16526 16576 "0000003116" ""     
1 0 18628 19083 19212 "0000003116" ""     
1 0 18628 18992 19418 "0000003116" ""     
1 0 19724 19996 20164 "0000003116" ""     
1 0 19724 20088 20202 "0000003116" ""     
1 0 19724 19813 20584 "0000003116" ""     
1 0 19905 19996 20123 "0000003146" ""     
1 0 19632 19813 20214 "0000003146" ""     
1 0 14245 15340 15774 "0000003153" "ALPVN"
1 0 14245 14609 15070 "0000003197" "CECE" 
1 0 14610 16344 16475 "0000003197" "CECE" 
1 0 14245 15430 15566 "0000003202" ""     
0 0 16071 16344 16428 "0000003202" ""     
1 0 17348 17439 17591 "0000003202" ""     
1 0 16802 17622 17828 "0000003202" ""     
1 0 14518 16344 16547 "0000003370" ""     
1 0 18628 19174 19305 "0000003453" "MATX" 
1 0 20454 20819 21126 "0000003453" "MATX" 
1 0 20089 21184 21612 "0000003453" "MATX" 
1 0 17257 17347 17468 "0000003499" "ALX"  
1 0 16680 17622 17881 "0000003545" "ALCO" 
1 0 19632 20361 20579 "0000003545" "ALCO" 
1 0 15157 15248 15431 "0000003570" "LNG"  
0 0 15066 15156 15292 "0000003673" ""     
1 0 15249 15340 15439 "0000003673" ""     
1 0 14976 15521 15663 "0000003673" ""     
1 0 13880 14152 14669 "0000003941" ""     
1 0 14976 16344 16511 "0000003952" ""     
1 0 15341 16526 16656 "0000003952" ""     
1 0 15341 16709 16751 "0000003952" ""     
1 0 16802 17074 17206 "0000003952" ""     
1 0 14213 14425 14741 "0000003959" ""     
1 0 15522 15613 15818 "0000003959" ""     
1 0 15341 15705 16205 "0000003959" ""     
1 0 15706 16070 16630 "0000003959" ""     
1 0 14976 15156 15244 "0000003982" ""     
1 0 15706 15978 16175 "0000003982" ""     
1 0 15706 16344 16471 "0000003982" ""     
1 0 15887 16070 16653 "0000003982" ""     
1 0 16071 16526 17240 "0000003982" ""     
1 0 18263 18627 18835 "0000003982" ""     
1 0 15341 15705 16160 "0000004164" ""     
1 0 16071 16709 16777 "0000004164" ""     
1 0 14610 14700 15236 "0000004165" ""     
1 0 17257 17347 17484 "0000004187" ""     
1 0 21915 22096 22134 "0000004281" "HWM"  
1 0 21915 22096 22228 "0000004281" "HWM"  
1 0 21550 21822 22228 "0000004281" "HWM"  
1 0 15553 16467 16538 "0000004344" ""     
1 0 14610 14975 15197 "0000004457" "UHAL" 
1 0 14701 15340 15427 "0000004457" "UHAL" 
1 0 15522 15613 15837 "0000004457" "UHAL" 
1 0 14518 14975 15197 "0000004458" ""     
1 0 15066 15340 15427 "0000004458" ""     
1 0 14335 15430 15538 "0000004458" ""     
1 0 16802 17166 17224 "0000004515" ""     
1 0 17898 18170 18567 "0000004904" "AEP"  
1 0 17167 18352 18479 "0000004962" "AXP"  
1 0 17898 18170 18569 "0000004962" "AXP"  
1 0 18263 18352 18751 "0000004962" "AXP"  
1 0 18263 18992 19411 "0000004962" "AXP"  
1 0 18263 18992 20143 "0000004962" "AXP"  
1 0 19724 19904 20207 "0000004962" "AXP"  
1 0 20179 20453 20661 "0000004962" "AXP"  
0 0 17167 17897 18217 "0000004969" ""     
1 0 17898 18170 18352 "0000004969" ""     
1 0 16861 18870 18940 "0000005133" ""     
1 0 19418 19782 19918 "0000005133" ""     
1 1 14610 16436 16557 "0000005272" "AIG"  
1 0 14610 16617 16749 "0000005272" "AIG"  
1 0 18079 18170 18207 "0000005272" "AIG"  
1 0 19724 19996 20030 "0000005272" "AIG"  
1 0 14610 15613 15788 "0000005513" "UNM"  
1 0 16588 16952 17297 "0000005656" "AIVN" 
1 0 19017 19358 19537 "0000005656" "AIVN" 
1 0 15796 15978 16236 "0000005768" ""     
1 0 14245 14609 15082 "0000005907" ""     
1 0 14976 15065 15197 "0000005907" ""     
1 0 18628 18992 19418 "0000005981" "AVD"  
1 0 20089 20453 20885 "0000005981" "AVD"  
end
format %td RES_BEGIN_DATE
format %td RES_END_DATE
format %td FILE_DATE

https://www.statalist.org/forums/for...ear-identifier
The above is the suggestion William provide for generating restatement year, and I think it can be started from there. file_date is the disclose date to the public that it has restated previous years reports in.
Best wishes,
Qiaoye