Search found 34 matches

by nesheus
Thu Dec 09, 2010 7:52 am
Forum: Programming
Topic: Exporting a table into other software with the formatings
Replies: 1
Views: 3185

Exporting a table into other software with the formatings

Hello,
Is there a way of exporting the table created in Eviews to Excel or other software by preserving the format? When I save it as CSV or copy paste into Excel I lose all the lines and formating
Thanks
by nesheus
Tue Dec 07, 2010 1:53 pm
Forum: Programming
Topic: skip one observation in a sample
Replies: 3
Views: 4767

Re: skip one observation in a sample

I want to exclude only one observation in 2008Q4. In your answer there are 2 quarters, why?
by nesheus
Tue Dec 07, 2010 1:32 pm
Forum: Programming
Topic: skip one observation in a sample
Replies: 3
Views: 4767

skip one observation in a sample

Hello, I have a sample from 1990Q1 to 2010Q3. I want to exclude the value in one quarter: 2008Q4. This is what I am doing but is there a more efficient way of doing it, the version of eviews I have is 6 smpl 2008Q4 2008Q4 series mse1_10=na smpl @first @last scalar rmse1c_10=@sqrt(@mean(mse1_10)) tha...
by nesheus
Wed Dec 01, 2010 2:22 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

That is what I am doing here in the if statement

if (@isna(eqalum1_12c.@tstat(1))=0) then


but I get an error message of division by zero and the program stops.
by nesheus
Wed Dec 01, 2010 2:17 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

The regression does not have errors. Simply it doesn't converge. So when I try to calculate the t-statistics I get an error. Could you read my earlier messages. I should find a way of detecting that this regression did not do any estimation. I tried @coeff etc but could find a way. when i try t-stat...
by nesheus
Wed Dec 01, 2010 1:54 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

Could you respond to my question on what to check without interrupting the program and skip this regression?
Thanks
by nesheus
Wed Dec 01, 2010 1:14 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

Also, I cannot find this function, @lasterrnum? Where do you go or how do you search? I don't think Eviews help is easy to find anything by simply typing.
by nesheus
Wed Dec 01, 2010 1:12 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

Actually, I should also point out that the regression line doesn't create any error. Only when i try to use the tstatistics I get an error (division by zero).
by nesheus
Wed Dec 01, 2010 1:08 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

Re: How to skip a regression when it has an error

thanks. Are you sure the spelling is correct because I get this error when I used it
@lasterrnum is an illegal or reserved name
by nesheus
Wed Dec 01, 2010 12:58 pm
Forum: Programming
Topic: How to skip a regression when it has an error
Replies: 12
Views: 13279

How to skip a regression when it has an error

Please see a segment of my program. In the regression equation, it cannot produce coefficients because it has a singular matrix. So tstat(1) gives "division by zero" error and stops the program. I do this for many equations in a very long program. I need to detect this error and skip to ca...
by nesheus
Thu Nov 18, 2010 4:51 pm
Forum: Programming
Topic: outputing years in a table
Replies: 7
Views: 7531

Re: outputing years in a table

I know to put the numbers in the table. If you look at my original posting the forecast window changes so I don't know the years.
Anyway I found a way to do it.
by nesheus
Thu Nov 18, 2010 4:06 pm
Forum: Programming
Topic: outputing years in a table
Replies: 7
Views: 7531

Re: outputing years in a table

I am trying to report forecast numbers with years. I cannot put the years on the title as I epxlained in the beginning of my posting.
thanks a lot for your help.
by nesheus
Thu Nov 18, 2010 3:32 pm
Forum: Programming
Topic: outputing years in a table
Replies: 7
Views: 7531

Re: outputing years in a table

scalar yy=@first expression doesn't work!
by nesheus
Thu Nov 18, 2010 2:45 pm
Forum: Programming
Topic: outputing years in a table
Replies: 7
Views: 7531

outputing years in a table

How can I put the years as title in a table. I have tried this and didn't work. Can you recommend a solution please? thanks

scalar yy=@first

for !j=1 to 20
setcell(results,3,4+!j,yy+!j)
next

Go to advanced search