## Search found 9 matches

Thu Jan 31, 2019 7:22 pm
Forum: Programming
Topic: export data with no #N/A in blanks
Replies: 0
Views: 818

### export data with no #N/A in blanks

Hi, I have a little trouble about exporting data from eviews work-file to excel because there are #N/A in blanks event I command to avoid the case. How can I adapt my code to delete #N/A in my blank cell. This is my code (I understand that na= blank is a key to solve my problem. However, after I try...
Tue Jan 08, 2019 2:36 am
Forum: Programming
Topic: How can I stack data into pivot form
Replies: 0
Views: 825

### How can I stack data into pivot form

Hi, I would like to know is there a way to command time series data into stack data like pivot form as example below If I can command directly to simple platform as I show in the picture please tell me. thank you so much Chairat -----------------------------------------------------------------------...
Sun Dec 16, 2018 10:46 pm
Forum: Programming
Topic: How to code for putting average MAE from rolling forecast into table
Replies: 3
Views: 1214

### Re: How to code for putting average MAE from rolling forecast into table

Thank you for your reply EViews Gareth but I have ever try the way as your recommend. by @sum(.......)/7 zresult_{%n}(10,2) = @sum(@mae({%n}_r{!m}f,{%n}))/7 but the program tell the error that Scalar sent to function which operates on a matrix in "ZRESULT_{%N}(10,2) = @SUM(@MAE(BMIX_E_R1F,BMIX_...
Sun Dec 16, 2018 4:07 am
Forum: Programming
Topic: How to code for putting average MAE from rolling forecast into table
Replies: 3
Views: 1214

### How to code for putting average MAE from rolling forecast into table

Hi,

I have problem to put average MAE from rolling forecast into table
because of type of scalar, matrix and string problem.
I would like to know how to code them.

Fri Dec 14, 2018 8:51 pm
Forum: Programming
Topic: regression loop doesn't work
Replies: 2
Views: 879

### Re: regression loop doesn't work

That's right!!! Thank you so much for quickly reply.
Fri Dec 14, 2018 2:15 am
Forum: Programming
Topic: regression loop doesn't work
Replies: 2
Views: 879

### regression loop doesn't work

Hi, I am sorry for leaving many questions in the post because I am a programming beginner. I attempt to code auto least square loop between G_MA3 and G_MA3_TC I_MA3 and I_MA3_TC M_MA3 and M_MA3_TC MS_MA3 and MS_MA3_TC X_MA3 and X_MA3_TC but my coding doesn't work could you please correct them. I att...
Fri Dec 14, 2018 2:05 am
Forum: Programming
Topic: convert series from %year on year to level
Replies: 2
Views: 916

### Re: convert series from %year on year to level

thank a lot
Thu Dec 13, 2018 8:02 pm
Forum: Programming
Topic: convert series from %year on year to level
Replies: 2
Views: 916

### convert series from %year on year to level

Hello, I want to know how to command eviews in this case Intro to the Questions I forecast y from growth form model that is @pcy(y) = c @pcy(x1) @pcy(x2) After that I get foretasted y for 12 months ahead . Then I must the foretasted @pcy(y) to y how I can code it. thank you in advance EX. Y (volume)...
Fri Nov 30, 2018 10:09 pm
Forum: Programming
Topic: How to command EViews to estimate least square for many equations in same time
Replies: 1
Views: 1103

### How to command EViews to estimate least square for many equations in same time

Hi, If I want to estimate 77 single (or multiple equation) by least square (time series model). Is there a way I can command EViews to estimate these equations in one time. Now, I know the command >>> equation eq_1.ls y x1 x2 x......... but I want to make the command for many equations in one time e...