EViews.com

Hi all, I figured it out by myself, but thank Gareth anyway for letting me know what I have to do. I needed more lines and thoughts than I expected to fix my codes above, but anyway the following codes worked. Hope this would be a help to somebody else who wants to do panel HP-filtering using EViews...

Hi Gareth, Thank you so much for your very quick reply! I'm trying to implement what you advised, but could you fix the following code? The problem is I cannot copy back the HP filtered series to the paneled page, matching the crossid that is being worked on. ' Create a page to conduct HP-filtering ...

Hi all, I would like to know any update available on this issue since EViews version 5. I'm using EViews version 7.2, but having a trouble in HP-filtering using panel data. My code is: ' Work on counry by country series temp = @crossid !ncross = @max(temp) delete temp for !i=1 to !ncross smpl if @cr...

Dear Gareth, Thank you so much for your really quick and precise help!! The code works well after deleting blanks. Honestly, I'm a bit embarrassed.... :oops: Usually, Eviews nicely interprets such blanks, so I didn't think it matters. I will check them from the next time. I really appreciate your he...

Hi, I keep having an error in using "setfillcolor" procedure of the table class object. I'd like to turn the cell into red if the estimated coefficient in the cell has an unexpected sign. I wrote a loop that executes the following two senteces; EST2_PANEL_ERRI3_S_1.setfillcolor (!row1,!col...

Thank you so much for your quick reply, QMS Jason!

OK, I understand the error in the User Guide.
And, your code works perfectly!
I really appreciate your help!

Thank you very much,
Futoshi

Hi, I have a question on how to program a loop where I can name objects at the same time I append the object to a spool object. What I like to do is to plot many graphs at once (to check if my data look right). So, I write a code as follows, according to a suggestion in this "programming" ...

I see how it went. Anyway, thank you very much!! :D
Futoshi

Dear QMS Gareth, I used this routine, and it works well! Thank you very much! By the way, although it works well, I found mis-notation of variables in this program. For xprev and xnext, you wrote series xprev = @sumsby(x, id(-1)) 'value of X before NAs series xnext = @sumsby(x, id) 'value of X after...

Thank you very much!!!

I just started using EViews one week ago, and learned a lot from you, QMS Gareth.
I truely appreciate your quick and precise help!

Thank you so much for taking your time, and have a nice weekend!
Futoshi

Hi, Is there any command to delete any series that contains only NAs? The excel files that I imported sometimes contain a series of all NAs. For example, there is a series of GDP in country A, whose GDP is not available in fact. In this case, my variable A_GDP contains NAs for all data periods. That...

Thank you so much, QMS Gareth.
Your code works perfectly.
I really appreciate your help! :D

Many thanks,
Futoshi

Hi, I'd like to connect numeric codes in one page with string codes in another page. The procedure in my mind is what is called "JOIN" in a database language, such as SQL. Specifically, I have one page that has two series of codes: one alpha series of 3 letter country codes, such as USA or...

Thank you so much!! Your code works well. You're great!
I'm really grateful for your quick and precise reply!

Many thanks,
Futoshi

Hi, I'd like to construct an unstacked panel data set from stacked data in an excel file. I'm using EViews 5.1. I attached the excel file that I have. It contains 3 letter country code (ccode), data year (year), and a variable of interest (kaopen). I'd like to read it as the format like this: (ccode...