Hi Guys,
Need help with dropping a variable. This is my data:
ccode ifscode country group region inc year
USA 111 United States Advanced Economies North America High Income 1990
USA 111 United States Advanced Economies North America High Income 1991
USA 111 United States Advanced Economies North America High Income 1992
USA 111 United States Advanced Economies North America High Income 1993
USA 111 United States Advanced Economies North America High Income 1994
USA 111 United States Advanced Economies North America High Income 1995
USA 111 United States Advanced Economies North America High Income 1996
USA 111 United States Advanced Economies North America High Income 1997
USA 111 United States Advanced Economies North America High Income 1998
USA 111 United States Advanced Economies North America High Income 1999
USA 111 United States Advanced Economies North America High Income 2000
USA 111 United States Advanced Economies North America High Income 2001
USA 111 United States Advanced Economies North America High Income 2002
USA 111 United States Advanced Economies North America High Income 2003
USA 111 United States Advanced Economies North America High Income 2004
USA 111 United States Advanced Economies North America High Income 2005
USA 111 United States Advanced Economies North America High Income 2006
USA 111 United States Advanced Economies North America High Income 2007
USA 111 United States Advanced Economies North America High Income 2008
USA 111 United States Advanced Economies North America High Income 2009
USA 111 United States Advanced Economies North America High Income 2010
USA 111 United States Advanced Economies North America High Income 2011
USA 111 United States Advanced Economies North America High Income 2012
USA 111 United States Advanced Economies North America High Income 2013
I have many variables. But I just copied a few rows to give an idea. The dataset is available at: https://www.worldbank.org/en/researc...f/fiscal-space
So under group we have Advanced Economies and EMDC. I want to drop all Advanced Economies countries and keep only the EMDC. So when I enter command:
. drop if group==Advanced Economies
I get an error: Advanced not found
Where am I going wrong? Thanks for your help.
Related Posts with Dropping variables
Can we determine the significance of changes over time using cross-sectional data?Dear Statalisters, I am using data from the 2011 and 2014 Demographic Health Surveys (these are rep…
Convert string variable to a date variableDear Stata Users I have a string variable yearmonth: for Jan 2004 it's stored as "200401". I need t…
need to drop duplicates depending on how many duplicates there are per observationI am trying to reshape my data from wide to long, however I need to drop duplicates first. Here is a…
Random seed neededI am looking for a number or string that will be different in different runs of the same program. So…
Getting Stata to recall the last opened directoryHi, I have been using Stata 13 on a Windows system and each time I start Stata, CTRL+O took me to t…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping variables
Post a Comment