fill numbers

[Yuxi Chen]

Hi,

May I ask how to fill missing Est_date with All_date up to Est_date2?

* Example generated by -dataex-. To install: ssc install dataex
clear
input float All_date str6 Security_id float(Est_date Est_date2)
540 ""         .   .
541 ""         .   .
542 ""         .   .
543 ""         .   .
544 ""         .   .
545 ""         .   .
546 ""         .   .
547 ""         .   .
548 ""         .   .
549 ""         .   .
550 ""         .   .
551 ""         .   .
552 ""         .   .
553 ""         .   .
554 "600089" 554 542
555 "002053" 555 543
556 ""         .   .
557 ""         .   .
558 ""         .   .
559 ""         .   .
560 "600017" 560 548
561 ""         .   .
562 ""         .   .
563 "000568" 563 551
564 "600383" 564 552
565 ""         .   .
566 ""         .   .
567 "600963" 567 555
568 "600655" 568 556
569 "600104" 569 557
570 ""         .   .
571 ""         .   .
572 "600489" 572 560
573 "600559" 573 561
574 ""         .   .
575 ""         .   .
576 ""         .   .
577 "002236" 577 565
578 ""         .   .
579 "002242" 579 567
580 ""         .   .
581 ""         .   .
582 ""         .   .
583 "000972" 583 571
584 ""         .   .
585 ""         .   .
586 ""         .   .
587 ""         .   .
588 ""         .   .
589 ""         .   .
590 ""         .   .
591 "600729" 591 579
592 "000501" 592 580
593 ""         .   .
594 ""         .   .
595 ""         .   .
596 "002304" 596 584
597 "002330" 597 585
598 ""         .   .
599 ""         .   .
600 "601989" 600 588
601 "000422" 601 589
602 "600125" 602 590
603 "600277" 603 591
604 "600228" 604 592
605 ""         .   .
606 ""         .   .
607 ""         .   .
608 ""         .   .
609 ""         .   .
610 ""         .   .
611 ""         .   .
612 "600863" 612 600
613 "600239" 613 601
614 ""         .   .
615 "000061" 615 603
616 ""         .   .
617 ""         .   .
618 "000780" 618 606
619 ""         .   .
620 "600157" 620 608
621 "002285" 621 609
622 ""         .   .
623 "002238" 623 611
624 ""         .   .
625 "002037" 625 613
626 "002353" 626 614
627 ""         .   .
628 "600123" 628 616
629 "000625" 629 617
630 ""         .   .
631 ""         .   .
632 "000100" 632 620
633 "600535" 633 621
634 ""         .   .
635 "600893" 635 623
636 ""         .   .
637 ""         .   .
638 "600252" 638 626
639 "600795" 639 627
end
format %tmCCYY-NN All_date
format %tmCCYY-NN Est_date
format %tmCCYY-NN Est_date2