Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Dropping Multiple Observation using DROP

    I am trying to drop multiple observation using DROP, however ending up with an error

    Code:
    drop if Ticker==TH:CMAN | Ticker==TH:COMAN
    I tried using " || " as well. Any suggestions would be great

    Below is sample of my data

    Code:
    * Example generated by -dataex-. For more info, type help dataex
    clear
    input str9 Ticker int Year long WC01651
    "TH:2S"  1994        .
    "TH:2S"  1995        .
    "TH:2S"  1996        .
    "TH:2S"  1997        .
    "TH:2S"  1998        .
    "TH:2S"  1999        .
    "TH:2S"  2000        .
    "TH:2S"  2001        .
    "TH:2S"  2002        .
    "TH:2S"  2003        .
    "TH:2S"  2004        .
    "TH:2S"  2005        .
    "TH:2S"  2006    34020
    "TH:2S"  2007    55390
    "TH:2S"  2008   112840
    "TH:2S"  2009    91864
    "TH:2S"  2010    71431
    "TH:2S"  2011    64980
    "TH:2S"  2012    52643
    "TH:2S"  2013    68031
    "TH:2S"  2014    41898
    "TH:7UP" 1994        .
    "TH:7UP" 1995        .
    "TH:7UP" 1996        .
    "TH:7UP" 1997        .
    "TH:7UP" 1998        .
    "TH:7UP" 1999        .
    "TH:7UP" 2000        .
    "TH:7UP" 2001    84000
    "TH:7UP" 2002   301429
    "TH:7UP" 2003  -123386
    "TH:7UP" 2004   178368
    "TH:7UP" 2005   179860
    "TH:7UP" 2006    67330
    "TH:7UP" 2007   146175
    "TH:7UP" 2008   125678
    "TH:7UP" 2009   126637
    "TH:7UP" 2010    66485
    "TH:7UP" 2011  -625090
    "TH:7UP" 2012   962232
    "TH:7UP" 2013    58762
    "TH:7UP" 2014  -214396
    "TH:A"   1994        .
    "TH:A"   1995        .
    "TH:A"   1996        .
    "TH:A"   1997        .
    "TH:A"   1998        .
    "TH:A"   1999        .
    "TH:A"   2000        .
    "TH:A"   2001        .
    "TH:A"   2002        .
    "TH:A"   2003    51542
    "TH:A"   2004   179015
    "TH:A"   2005     8721
    "TH:A"   2006     8191
    "TH:A"   2007   -78636
    "TH:A"   2008    32582
    "TH:A"   2009   518008
    "TH:A"   2010   427951
    "TH:A"   2011    76002
    "TH:A"   2012    94353
    "TH:A"   2013    13777
    "TH:A"   2014    41266
    "TH:A5"  1994        .
    "TH:A5"  1995        .
    "TH:A5"  1996        .
    "TH:A5"  1997        .
    "TH:A5"  1998        .
    "TH:A5"  1999        .
    "TH:A5"  2000        .
    "TH:A5"  2001        .
    "TH:A5"  2002    23850
    "TH:A5"  2003    29739
    "TH:A5"  2004    37936
    "TH:A5"  2005   -53245
    "TH:A5"  2006  -140825
    "TH:A5"  2007   -47732
    "TH:A5"  2008   -72508
    "TH:A5"  2009   -50292
    "TH:A5"  2010   -59916
    "TH:A5"  2011    -9658
    "TH:A5"  2012   -50444
    "TH:A5"  2013   -14595
    "TH:A5"  2014   -69825
    "TH:AA"  1994  -334257
    "TH:AA"  1995   -95536
    "TH:AA"  1996  -912982
    "TH:AA"  1997 -7011903
    "TH:AA"  1998  4768554
    "TH:AA"  1999 -3734238
    "TH:AA"  2000   628910
    "TH:AA"  2001   199010
    "TH:AA"  2002  1195095
    "TH:AA"  2003  1495941
    "TH:AA"  2004  1518619
    "TH:AA"  2005  1909528
    "TH:AA"  2006  1972180
    "TH:AA"  2007   430287
    "TH:AA"  2008        .
    "TH:AA"  2009        .
    end
    Last edited by Farhan Hasnat; 24 Jan 2022, 06:28. Reason: drop

  • #2
    the issue is that the strings must be enclosed in double quotes as in:
    Code:
    drop if Ticker=="TH:CMAN" | Ticker=="TH:COMAN"

    Comment


    • #3
      Rich Goldstein Thank you ! Appreciate your help in finding my mistake

      Comment

      Working...
      X