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.
From unbalanced to balanced panel data setDear all, I have an unbalanced panel dataset, which means that not all entities have data for all y…
What does dot mean in correlation matrix?Hi all, when running correlation matrix, I face the situation that the correlation is ".", I am won…
spmap code gives me no basemap data error despite data having _ID _CX _CY variablesHello, My current dataset for each county has _ID _CX _CY variables except for few counties. My mai…
Collecting Descriptive Stats (counts percentages) for categorical variables in a Postfile with a LoopHello, My goal is to collect counts and percentage of each level of a categorical variable in a Pos…
Obtain the timestamp of a fileI am seeking guidance about how to fetch the timestamp of a file from the file system. Searches with…
Subscribe to:
Post Comments (Atom)
0 Response to Create change variable for timeseries data.
Post a Comment