Hi, Stata users!
I have two questions. My first question is, I have labour and panel data, and I want to merge two datasets, meaning my data is separated by year and I want to join it for all years. My code is
merge m:1 idworker using /mnt/Labourdata/dct/workers00.dct
and Stata tells me
"file /mnt/Labourdata/dct/workers00.dct not Stata format".
What I should do to Stata read a dct file?
My second question is: since this is labour data, some individuals have more than one work. When I merge, how Stata proceeds with this individuals? I have this variables: year, idcompany, idworker, salary, etc. What I want is to sum all salaries of this individuals.
I have two questions. My first question is, I have labour and panel data, and I want to merge two datasets, meaning my data is separated by year and I want to join it for all years. My code is
merge m:1 idworker using /mnt/Labourdata/dct/workers00.dct
and Stata tells me
"file /mnt/Labourdata/dct/workers00.dct not Stata format".
What I should do to Stata read a dct file?
My second question is: since this is labour data, some individuals have more than one work. When I merge, how Stata proceeds with this individuals? I have this variables: year, idcompany, idworker, salary, etc. What I want is to sum all salaries of this individuals.
Comment