Hi,

I want to drop all data that is outside of my range. I tried following code
Code:
drop if monthly_date <600 & monthly_date >719
to keep data from 2010m1 to 2019m12 but somehow it deletes 0 observation.

Here is the example data (sorry that this dataset is a bit bigger than 100obs.)

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str12 isin float monthly_date
"CA00435L1085" 360
"CA00435L1085" 361
"CA00435L1085" 362
"CA00435L1085" 363
"CA00435L1085" 364
"CA00435L1085" 365
"CA00435L1085" 366
"CA00435L1085" 367
"CA00435L1085" 368
"CA00435L1085" 369
"CA00435L1085" 370
"CA00435L1085" 371
"CA00435L1085" 372
"CA00435L1085" 373
"CA00435L1085" 374
"CA00435L1085" 375
"CA00435L1085" 376
"CA00435L1085" 377
"CA00435L1085" 378
"CA00435L1085" 379
"CA00435L1085" 380
"CA00435L1085" 381
"CA00435L1085" 382
"CA00435L1085" 383
"CA00435L1085" 384
"CA00435L1085" 385
"CA00435L1085" 386
"CA00435L1085" 387
"CA00435L1085" 388
"CA00435L1085" 389
"CA00435L1085" 390
"CA00435L1085" 391
"CA00435L1085" 392
"CA00435L1085" 393
"CA00435L1085" 394
"CA00435L1085" 395
"CA00435L1085" 396
"CA00435L1085" 397
"CA00435L1085" 398
"CA00435L1085" 399
"CA00435L1085" 400
"CA00435L1085" 401
"CA00435L1085" 402
"CA00435L1085" 403
"CA00435L1085" 404
"CA00435L1085" 405
"CA00435L1085" 406
"CA00435L1085" 407
"CA00435L1085" 408
"CA00435L1085" 409
"CA00435L1085" 410
"CA00435L1085" 411
"CA00435L1085" 412
"CA00435L1085" 413
"CA00435L1085" 414
"CA00435L1085" 415
"CA00435L1085" 416
"CA00435L1085" 417
"CA00435L1085" 418
"CA00435L1085" 419
"CA00435L1085" 420
"CA00435L1085" 421
"CA00435L1085" 422
"CA00435L1085" 423
"CA00435L1085" 424
"CA00435L1085" 425
"CA00435L1085" 426
"CA00435L1085" 427
"CA00435L1085" 428
"CA00435L1085" 429
"CA00435L1085" 430
"CA00435L1085" 431
"CA00435L1085" 432
"CA00435L1085" 433
"CA00435L1085" 434
"CA00435L1085" 435
"CA00435L1085" 436
"CA00435L1085" 437
"CA00435L1085" 438
"CA00435L1085" 439
"CA00435L1085" 440
"CA00435L1085" 441
"CA00435L1085" 442
"CA00435L1085" 443
"CA00435L1085" 444
"CA00435L1085" 445
"CA00435L1085" 446
"CA00435L1085" 447
"CA00435L1085" 448
"CA00435L1085" 449
"CA00435L1085" 450
"CA00435L1085" 451
"CA00435L1085" 452
"CA00435L1085" 453
"CA00435L1085" 454
"CA00435L1085" 455
"CA00435L1085" 456
"CA00435L1085" 457
"CA00435L1085" 458
"CA00435L1085" 459
"CA00435L1085" 460
"CA00435L1085" 461
"CA00435L1085" 462
"CA00435L1085" 463
"CA00435L1085" 464
"CA00435L1085" 465
"CA00435L1085" 466
"CA00435L1085" 467
"CA00435L1085" 468
"CA00435L1085" 469
"CA00435L1085" 470
"CA00435L1085" 471
"CA00435L1085" 472
"CA00435L1085" 473
"CA00435L1085" 474
"CA00435L1085" 475
"CA00435L1085" 476
"CA00435L1085" 477
"CA00435L1085" 478
"CA00435L1085" 479
"CA00435L1085" 480
"CA00435L1085" 481
"CA00435L1085" 482
"CA00435L1085" 483
"CA00435L1085" 484
"CA00435L1085" 485
"CA00435L1085" 486
"CA00435L1085" 487
"CA00435L1085" 488
"CA00435L1085" 489
"CA00435L1085" 490
"CA00435L1085" 491
"CA00435L1085" 492
"CA00435L1085" 493
"CA00435L1085" 494
"CA00435L1085" 495
"CA00435L1085" 496
"CA00435L1085" 497
"CA00435L1085" 498
"CA00435L1085" 499
"CA00435L1085" 500
"CA00435L1085" 501
"CA00435L1085" 502
"CA00435L1085" 503
"CA00435L1085" 504
"CA00435L1085" 505
"CA00435L1085" 506
"CA00435L1085" 507
"CA00435L1085" 508
"CA00435L1085" 509
"CA00435L1085" 510
"CA00435L1085" 511
"CA00435L1085" 512
"CA00435L1085" 513
"CA00435L1085" 514
"CA00435L1085" 515
"CA00435L1085" 516
"CA00435L1085" 517
"CA00435L1085" 518
"CA00435L1085" 519
"CA00435L1085" 520
"CA00435L1085" 521
"CA00435L1085" 522
"CA00435L1085" 523
"CA00435L1085" 524
"CA00435L1085" 525
"CA00435L1085" 526
"CA00435L1085" 527
"CA00435L1085" 528
"CA00435L1085" 529
"CA00435L1085" 530
"CA00435L1085" 531
"CA00435L1085" 532
"CA00435L1085" 533
"CA00435L1085" 534
"CA00435L1085" 535
"CA00435L1085" 536
"CA00435L1085" 537
"CA00435L1085" 538
"CA00435L1085" 539
"CA00435L1085" 540
"CA00435L1085" 541
"CA00435L1085" 542
"CA00435L1085" 543
"CA00435L1085" 544
"CA00435L1085" 545
"CA00435L1085" 546
"CA00435L1085" 547
"CA00435L1085" 548
"CA00435L1085" 549
"CA00435L1085" 550
"CA00435L1085" 551
"CA00435L1085" 552
"CA00435L1085" 553
"CA00435L1085" 554
"CA00435L1085" 555
"CA00435L1085" 556
"CA00435L1085" 557
"CA00435L1085" 558
"CA00435L1085" 559
"CA00435L1085" 560
"CA00435L1085" 561
"CA00435L1085" 562
"CA00435L1085" 563
"CA00435L1085" 564
"CA00435L1085" 565
"CA00435L1085" 566
"CA00435L1085" 567
"CA00435L1085" 568
"CA00435L1085" 569
"CA00435L1085" 570
"CA00435L1085" 571
"CA00435L1085" 572
"CA00435L1085" 573
"CA00435L1085" 574
"CA00435L1085" 575
"CA00435L1085" 576
"CA00435L1085" 577
"CA00435L1085" 578
"CA00435L1085" 579
"CA00435L1085" 580
"CA00435L1085" 581
"CA00435L1085" 582
"CA00435L1085" 583
"CA00435L1085" 584
"CA00435L1085" 585
"CA00435L1085" 586
"CA00435L1085" 587
"CA00435L1085" 588
"CA00435L1085" 589
"CA00435L1085" 590
"CA00435L1085" 591
"CA00435L1085" 592
"CA00435L1085" 593
"CA00435L1085" 594
"CA00435L1085" 595
"CA00435L1085" 596
"CA00435L1085" 597
"CA00435L1085" 598
"CA00435L1085" 599
"CA00435L1085" 600
"CA00435L1085" 601
"CA00435L1085" 602
"CA00435L1085" 603
"CA00435L1085" 604
"CA00435L1085" 605
"CA00435L1085" 606
"CA00435L1085" 607
"CA00435L1085" 608
"CA00435L1085" 609
"CA00435L1085" 610
"CA00435L1085" 611
"CA00435L1085" 612
"CA00435L1085" 613
"CA00435L1085" 614
"CA00435L1085" 615
"CA00435L1085" 616
"CA00435L1085" 617
"CA00435L1085" 618
"CA00435L1085" 619
"CA00435L1085" 620
"CA00435L1085" 621
"CA00435L1085" 622
"CA00435L1085" 623
"CA00435L1085" 624
"CA00435L1085" 625
"CA00435L1085" 626
"CA00435L1085" 627
"CA00435L1085" 628
"CA00435L1085" 629
"CA00435L1085" 630
"CA00435L1085" 631
"CA00435L1085" 632
"CA00435L1085" 633
"CA00435L1085" 634
"CA00435L1085" 635
"CA00435L1085" 636
"CA00435L1085" 637
"CA00435L1085" 638
"CA00435L1085" 639
"CA00435L1085" 640
"CA00435L1085" 641
"CA00435L1085" 642
"CA00435L1085" 643
"CA00435L1085" 644
"CA00435L1085" 645
"CA00435L1085" 646
"CA00435L1085" 647
"CA00435L1085" 648
"CA00435L1085" 649
"CA00435L1085" 650
"CA00435L1085" 651
"CA00435L1085" 652
"CA00435L1085" 653
"CA00435L1085" 654
"CA00435L1085" 655
"CA00435L1085" 656
"CA00435L1085" 657
"CA00435L1085" 658
"CA00435L1085" 659
"CA00435L1085" 660
"CA00435L1085" 661
"CA00435L1085" 662
"CA00435L1085" 663
"CA00435L1085" 664
"CA00435L1085" 665
"CA00435L1085" 666
"CA00435L1085" 667
"CA00435L1085" 668
"CA00435L1085" 669
"CA00435L1085" 670
"CA00435L1085" 671
"CA00435L1085" 672
"CA00435L1085" 673
"CA00435L1085" 674
"CA00435L1085" 675
"CA00435L1085" 676
"CA00435L1085" 677
"CA00435L1085" 678
"CA00435L1085" 679
"CA00435L1085" 680
"CA00435L1085" 681
"CA00435L1085" 682
"CA00435L1085" 683
"CA00435L1085" 684
"CA00435L1085" 685
"CA00435L1085" 686
"CA00435L1085" 687
"CA00435L1085" 688
"CA00435L1085" 689
"CA00435L1085" 690
"CA00435L1085" 691
"CA00435L1085" 692
"CA00435L1085" 693
"CA00435L1085" 694
"CA00435L1085" 695
"CA00435L1085" 696
"CA00435L1085" 697
"CA00435L1085" 698
"CA00435L1085" 699
"CA00435L1085" 700
"CA00435L1085" 701
"CA00435L1085" 702
"CA00435L1085" 703
"CA00435L1085" 704
"CA00435L1085" 705
"CA00435L1085" 706
"CA00435L1085" 707
"CA00435L1085" 708
"CA00435L1085" 709
"CA00435L1085" 710
"CA00435L1085" 711
"CA00435L1085" 712
"CA00435L1085" 713
"CA00435L1085" 714
"CA00435L1085" 715
"CA00435L1085" 716
"CA00435L1085" 717
"CA00435L1085" 718
"CA00435L1085" 719
"CA0636711016" 360
"CA0636711016" 361
"CA0636711016" 362
"CA0636711016" 363
"CA0636711016" 364
"CA0636711016" 365
"CA0636711016" 366
"CA0636711016" 367
"CA0636711016" 368
"CA0636711016" 369
"CA0636711016" 370
"CA0636711016" 371
"CA0636711016" 372
"CA0636711016" 373
"CA0636711016" 374
"CA0636711016" 375
"CA0636711016" 376
"CA0636711016" 377
"CA0636711016" 378
"CA0636711016" 379
"CA0636711016" 380
"CA0636711016" 381
"CA0636711016" 382
"CA0636711016" 383
"CA0636711016" 384
"CA0636711016" 385
"CA0636711016" 386
"CA0636711016" 387
"CA0636711016" 388
"CA0636711016" 389
"CA0636711016" 390
"CA0636711016" 391
"CA0636711016" 392
"CA0636711016" 393
"CA0636711016" 394
"CA0636711016" 395
"CA0636711016" 396
"CA0636711016" 397
"CA0636711016" 398
"CA0636711016" 399
end
format %tm monthly_date


Thanks