Page 1 of 2

Selecting data within the series - EV8

Posted: Sat Aug 29, 2015 3:19 pm
by H_Boss
Hello,

I have series with multiple countries. Is it possible to filter 1 or several countries on estimation?


Thanx,

HB

Re: Selecting data within the series - EV8

Posted: Sat Aug 29, 2015 3:34 pm
by EViews Gareth
Probably, but without more details it is impossible to give advice.

Re: Selecting data within the series - EV8

Posted: Sat Aug 29, 2015 7:50 pm
by H_Boss
I wish to do the estimation with only 1 or some o'the countries in the series.
Is there a command like in SQL, "where country=Austria", f.e.?


HB

Re: Selecting data within the series - EV8

Posted: Sat Aug 29, 2015 7:58 pm
by EViews Gareth
Set the sample to be

Code: Select all

If county = "Austria"

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 6:20 am
by H_Boss
? on the estimation equation?

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 7:40 am
by EViews Gareth
Yes

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 7:45 am
by H_Boss
Error... "Near singular matrix."

Is this correct?
1980 2012 if country = "Austria"

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:04 am
by EViews Gareth
That's correct.

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:26 am
by H_Boss
Why the error then?

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:39 am
by startz
Do you have a variable with constant value for Austria?

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:41 am
by H_Boss
No, the values for Austria vary over the years 1980-2012. As for other countries.

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:49 am
by startz
You might want to form the correlation matrix of all your right hand side variables, keeping the sample to Austria. Or you might want to post your workfile to see if anyone else sees anything.

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 8:52 am
by H_Boss
Here it is...

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 9:21 am
by startz
Please remember that while you're deeply involved, no one else understands the context. You need to tell us what equation you estimated, what options you used, etc.

Re: Selecting data within the series - EV8

Posted: Sun Aug 30, 2015 9:31 am
by H_Boss
Equation: logco2 c logres loghydro logfossil lognuclear loggdp logindustry urbpop
Method: Least squares, 1980 2012
Fixed effects, GLS: No weights.
Coef covariance method: I'm still trying to find that out (diff. post), using "Period weights" for now.