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
Search found 34 matches
- Thu Dec 09, 2010 7:52 am
- Forum: Programming
- Topic: Exporting a table into other software with the formatings
- Replies: 1
- Views: 3185
- 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?
- 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...
- 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.
if (@isna(eqalum1_12c.@tstat(1))=0) then
but I get an error message of division by zero and the program stops.
- 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...
- 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
Thanks
- Wed Dec 01, 2010 1:51 pm
- Forum: Programming
- Topic: How to skip a regression when it has an error
- Replies: 12
- Views: 13279
- 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.
- 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).
- 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
@lasterrnum is an illegal or reserved name
- 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...
- 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.
Anyway I found a way to do it.
- 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.
thanks a lot for your help.
- 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!
- 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
scalar yy=@first
for !j=1 to 20
setcell(results,3,4+!j,yy+!j)
next
