Hi,
my problem is twofold. I downloaded a database containing gvkey, sic code, year (1995 - 2005), year-end date, and 13 variables, for about 3000 US companies. This information is organized in columns, with the first company taking the first 11 rows (years), directly followed by the next company. I have to create new variables that represent year-to-year change. I was unable to find the syntax for this command, although I assume this to be quite straightforward (like in Excel). The second problem is the necessary leap from one company to the next. How do I tell STATA to end the subtraction at the end of a certain company (year 2005), to continue with the next. Is this even possible?
Related Posts with Create change variable for timeseries data.
Unit root test for unbalanced panelsHi! I am using data from the British Household Panel Survey which is an unbalanced panel. I am prim…
merge on most recent fiscal year endHi Statalist, I am trying to merge an annual dataset with a quarterly dataset based on most recent …
Dropping missing observations under several conditionsHej Statalist, I have a problem with dropping some observations. I analyse a trade data set and hav…
Regress dummy variable correctlyHello, I have generated a dummy variable "cellar" with has 3 answers: 1 large basement, 2 small bas…
Manipulate x-axis in twoway graph with dates Hi Stata users, I want to make a twoway bar graph that plots a number (on the y axis) against a dat…
Subscribe to:
Post Comments (Atom)
0 Response to Create change variable for timeseries data.
Post a Comment