I am trying to drop multiple observation using DROP, however ending up with an error
I tried using " || " as well. Any suggestions would be great
Below is sample of my data
Code:
drop if Ticker==TH:CMAN | Ticker==TH:COMAN
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
Comment