okay that seems to work
thanks!
Search found 4 matches
- Thu Feb 16, 2012 3:26 pm
- Forum: Data Manipulation
- Topic: Summing Series in Panel Data
- Replies: 6
- Views: 4545
- Thu Feb 16, 2012 9:37 am
- Forum: Data Manipulation
- Topic: Summing Series in Panel Data
- Replies: 6
- Views: 4545
Re: Summing Series in Panel Data
Hi Gareth,
That seems to give the sum of NVAL for each year for all the industries (I have some 95 of them). If I just want to add industry 1 and 2, how would I do that? (I need to aggregate a number of different industries into larger sector categories).
Cheers,
Nik
That seems to give the sum of NVAL for each year for all the industries (I have some 95 of them). If I just want to add industry 1 and 2, how would I do that? (I need to aggregate a number of different industries into larger sector categories).
Cheers,
Nik
- Thu Feb 16, 2012 9:08 am
- Forum: Data Manipulation
- Topic: Summing Series in Panel Data
- Replies: 6
- Views: 4545
Re: Summing Series in Panel Data
Hi Gareth, Thanks for helping me on this! I thought I had a panel? I opened the data as a dated panel with a time series identifier and a cross-section identifier. Here's what it looks like: http://img815.imageshack.us/img815/7553/onprodpicture.png NVAL is nominal value added, HRS is hours worked th...
- Thu Feb 16, 2012 8:39 am
- Forum: Data Manipulation
- Topic: Summing Series in Panel Data
- Replies: 6
- Views: 4545
Summing Series in Panel Data
Hey guys, I have a panel set up. I have industries identified by an industry code as the cross-section, and years as the time series identifiers. IE: INDCODE YEAR GDP EMP 1 95 25 100 1 96 28 134 1 97 39 148 1 98 56 150 2 95 15 32 2 96 19 22 2 97 25 21 2 98 32 24 etc. So my question is, how do I comb...