Hello everyone,
I have a panel data set containing unique company identifiers, fiscal year end and total assets.
I'm looking to create a change variable indicating the change of total assets from year t-1 to year t.
an extract of the data looks like this:
Code:
egen panelid = group(isin)
xtset panelid fye
bysort panelid fye:gen chTA = total_assets-L.total_assets
stata ouput shows: "1,034 missing values generated",which failed the task.
Does anyone has a suggestion?
Thank you in advance
I have a panel data set containing unique company identifiers, fiscal year end and total assets.
I'm looking to create a change variable indicating the change of total assets from year t-1 to year t.
an extract of the data looks like this:
isin_identifier | total_assets | fiscal_year_end |
"DE0003304002" | 564254 | Dec 31 05 |
"DE0003304002" | 621866 | Dec 31 06 |
"DE0003304002" | 967840 | Dec 31 07 |
"DE0003304002" | 1044262 | Dec 31 08 |
"DE0003304101" | 232795 | Oct 31 06 |
"DE0003304101" | 270419 | Oct 31 07 |
"DE0003304101" | 296583 | Oct 31 08 |
"DE0003304101" | 290596 | Oct 31 09 |
egen panelid = group(isin)
xtset panelid fye
bysort panelid fye:gen chTA = total_assets-L.total_assets
stata ouput shows: "1,034 missing values generated",which failed the task.
Does anyone has a suggestion?
Thank you in advance
Comment