EViews.com

Posted: **Wed Jun 05, 2013 8:35 am**

Hi,
I have a panel, containing US50, USTER and USA cross-sections. I need to define USA as the sum of US50 and USTER for all variables. I am struggling with how to do this. Thank you
Lenka

Posted: **Wed Jun 05, 2013 8:57 am**

Probably an easier way, but this will work:

Code: Select all


group all x y z
sample s1 if cross="USTER" or cross="US50"

for !i=1 to all.@count
	smpl @all
	%n = all.@seriesname(!i)
	series temp = @sumsby({%n}, @obsid, s1)
	smpl if cross="USA"
	{%n} = temp
	d temp
next

smpl @all

Where you replace "x y z" with the names of your variables, and "cross" with the name of your cross-section ID series.

Posted: **Fri Jun 07, 2013 3:09 am**

Thanks,
works perfect.

EViews.com

panel data: calculate a cross-section as the sum of 2 others

panel data: calculate a cross-section as the sum of 2 others

Re: panel data: calculate a cross-section as the sum of 2 ot

Re: panel data: calculate a cross-section as the sum of 2 ot