Hey there,
I'm a student working with Stata and have a data set that contains a variable associated with countries denoting their GDP from last year. However, I need the data to denote this year's GDP. If I "by country: gen GDP = gdplag[_n+1]" and then "drop if GDP == ." It successfully moves all gdplag observations one year to give me GDP while dropping the observations that don't have a gdplag. So I'm almost there. The problem is some of the years in the data set are nonconsecutive. For example, I have the years 1993, 1994, 1996, and 1997. Years 1993 and 1996 end up with accurate GDPs because I can obtain them from the gdplag of 1994 and 1997 respectively. Further, the GDP observation for 1997 is dropped since I don't have gdplag for 1998. However, the gdplag for 1996 becomes the GDP for 1994 when it is actually the GDP for 1995. Is it possible to make sure that gdplag is moved to correspond with the appropriate year? This is my best guess but I get an invalid syntax (r198) error: "by country: gen GDP = gdplag[_n+1] if year[_n] - year[_n-1] = 1"
Related Posts with Dropping Variables Based on Other Variable, Student Project
Combining locals that contain whitespaceI have a series of locals of the form: Code: local list1 "June 2004" local list2 "July 2004" …
Panel data of M&A's and patenting activityHello, I have a question that is a bit general, but hopefully somebody can help me since I’m quite …
Importing CSV file with surrounding single quotesI'm attempting to import data in a CSV file, where almost all variable values are surrounded by sing…
T-Test between two varibles with dummy conditionHey, I woul like to know how I could do the t-test between 2 variables if I calculated the mean with…
Combining plots in StataDear all, I wonder if anyone knows how to combine plots in Stata, considering a case when both figur…
Subscribe to:
Post Comments (Atom)
0 Response to Dropping Variables Based on Other Variable, Student Project
Post a Comment