"Insufficient number of observations"- problem

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

"Insufficient number of observations"- problem

Postby lomfy » Tue Jul 19, 2011 3:06 pm

Hi there!
I try to run regression for 96 sets of dependent variables ("rs") and independent variables (mam) of the following simple form...

for !i=1 to 96
equation eq!i.ls rs!i=c(1)+c(2)*mam!i
next

which should result in the same equation objects as...

equation eq1.ls(h) rs1=c(1)+c(2)*mam1
....
equation eq8.ls(h) rs8=c(1)+c(2)*mam8
equation eq9.ls(h) rs9=c(1)+c(2)*mam9
equation eq10.ls(h) rs10=c(1)+c(2)*mam10
equation eq11.ls(h) rs11=c(1)+c(2)*mam11
equation eq12.ls(h) rs12=c(1)+c(2)*mam12
...

However, with some of the datasets there appears to be an issue as i get the message "insufficent number of observations" - no equations are written for these datasets and the process terminates. I've checked the datasets thoroughly, they are all of the same lenght (241 entries).

Any hint how to automatically get estimations for all datasets? (The mistake also appears if I create the equations manually, as indicated above [without the "for" clause])

Thanks a lot!!

Wolfgang
Attachments
usd_nfp_5.wf1
Workfile
(493.79 KiB) Downloaded 300 times
Unbenannt.gif
Screenshot of error message
Unbenannt.gif (222.75 KiB) Viewed 9272 times

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: "Insufficient number of observations"- problem

Postby startz » Tue Jul 19, 2011 4:56 pm

rs13 is all NA and mam13 is all zero

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

Re: "Insufficient number of observations"- problem

Postby lomfy » Tue Jul 19, 2011 10:50 pm

Hi startz!

Yes, I'm aware of that ... in the first place I thought this might e the only problem.
However, even if I enter

for !i=14 to 96
equation eq!i.ls rs!i=c(1)+c(2)*mam!i
next

the program finds this mistakes, and even in datasets, that do not have this issue (see e.g. the screenshot example with rs28 and mam28m, which are perfectly ok as far a I can see!). It's about those instances that I care...I'll ignore the empty data sets (I think 13 is the only set with this problem with this issue in the whole database)...

What about the mistake with regards to those sets that are/look perfectly fine?

Thanks!

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

Re: "Insufficient number of observations"- problem

Postby lomfy » Tue Jul 19, 2011 11:38 pm

Moreover:

When i run the programme repeatedly, the mistake occurs in different runs with different data sets!

For example:

- 1. time: when i ran it for 90 - 96, first there was a mistake at 92
- 2. time: when i ran it again (without change), there was a mistake at 90
- 3. time: when i ran it the third time, there was no mistake at all!

Each time there is a mistake and i doubleclick the respective equation it says "Equation estimates are not valid".

What can i do? If I had to estimate only those 96 equations I would simply write down the results as soon as I get them
(repeat the procedure until I collected reasonable results for all equations [without number 13])
-
the problem is: I have to estimate approx. 12.000 equations in this manner (120 times databases with 96 time series),
so I really need to automate this thing...!

Any help with this issue?

Thanks!

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: "Insufficient number of observations"- problem

Postby startz » Wed Jul 20, 2011 7:16 am

There is certainly something very odd going on. Why don't you:
(1) Update your copy of of EViews.
(2) Post the workfile and program that actually cause the error.
(3) Hope for a GarethRescue.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: "Insufficient number of observations"- problem

Postby EViews Gareth » Wed Jul 20, 2011 7:56 am

I ran the following:

Code: Select all

for !i=1 to 96 if !i<>13 then equation eq!i.ls rs!i=c(1)+c(2)*mam!i endif next
(i.e. take your code and skip over the one problematic case that Startz pointed out), and ran it 50 times in a row. Every time it was able to estimate every equation fine.

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

Re: "Insufficient number of observations"- problem

Postby lomfy » Fri Jul 22, 2011 2:38 pm

well....i'll get eviews 7 in about a week from now - then i'll try again! hopefully it's a problem with this version...i'let you know!

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: "Insufficient number of observations"- problem

Postby EViews Gareth » Fri Jul 22, 2011 2:49 pm

The screenshot you posted was from EViews 7...

lomfy
Posts: 36
Joined: Mon Jul 18, 2011 11:51 pm

Re: "Insufficient number of observations"- problem

Postby lomfy » Tue Jul 26, 2011 1:09 am

:shock: i wonder, as i ran the programme on my colleagues computer and the first thing she told me was that she did not have the latest eviews version
(so i didn't look up the version on her computer and assumed it was 6)...well if the mistake happens even on 7 that's not good :/ i'll have to wait and see whether my version will handle it...


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests