EViews.com

Many thanks, very clear! So in line with your reply, the following works as expected, i.e. lag1 = lag2 wfcreate dd 2000 2020 ' create annual lag series lag1=@datediff(@date, @dateadd(@date,1,"A"), "dd") ' crate lagged date series, lagged by one year series dat=@date ' series date...

Dear Eviews team, I am using Eviews 14, Jun 16 2026 build. I obtain an unexpected result with the function @datediff, see attached code. I would have expected the series lag1 and lag 2 to show identical values all over. In fact, that is the case only in leap years Can you explain why the series lag1...

Using Eviews 14 Dec 26 2024 build Tables with empty cells behave unexpectedly in a loop search for a string. The search would unexpectedly stop once the loop reaches an empty cell, see code below. wfcreate u 1 ' create table with four rows and one column table(4,1) tab ' Filling the table, but leavi...

I use Eviews 14 Dec26 2024 build The function @rinstr does not work as described in the help documentation which says: Starting at the end of the string and searching in reverse, finds the starting position of the target string str2 in the string str1. By default, the function returns the location o...

So here is a workaround for @makedate with years & weeks as arguments not working: Assume you have an unordered workfile containing variables indicating year and week of the year, "year" and "week", respectively. In order to generate a proper date series "date" out ...

Hm, @dateval works fine and as expected with a monthly date as argument in any workfile context. There seems to be an issue with calendar-week dates in Eviews. wfcreate m 2000M01 2010M12 show @dateval("2009M04", "yyyy[M]mm") wfcreate u 1 show @dateval("2009M04", "y...

p1.png Well, the functions @dateval and @datepart(@date, week) obviously assign 1) a date to a specified week and 2) a week to a specified date, respectively. So there seems to be a uniquely defined link between weeks and dates (as is also the case with months and dates). So suggestion here. Please...

Hi, using Eviews 14 Dec 2024 build.
What is wrong with the following command line? Unexpectedly, it produces the error message "Bad date format 'yyyyww' - Missing data generated."

Okay, I managed to find an approach that works:

Hi everybody, using EVIEWS 14. Question: How do you define a sample in panel data set so that the sample comprises all cross sections with no NAs in the selected date range? See example in the files attached: If the selected data range is 2001 - 2010 only crossids 1 and 2 should be in the sample. Wi...

Dear Eviews team, I use Eviews 14 Dec 2024 build. Eviews crashes after some spool operations. The sequence of events making Eviews crash is as follows: 1 Open an object within a spool by mouse click on that object 2 Close the spool w/o closing the object first. 3 Open the spool again by mouse click ...

Dear Eviews Matt,
many thanks, indeed this works!
My suggestion would be include a reference to the documentation of @firstsby into the index so that it can be found easily.
Same applies to @lastsby Best, mamo

Dear EViews team, I am using EViews 14 I suggest that you improve the @first(x) function to work proper in panels so that it allows for showing the first value of series x in each cross section in the preselected sample. To give an example, I would like to have an easy function which would show the ...

Dear Eviews team, I use Eviews 13 October 2022 build. Why is that the matrices m1 m1a in the code example below are of dimension 3X1 rather than 1X3? I would expect the extraction of a row from a 3X3 matrix to yield a matrix of dimension 1X3 wfcreate u 1 1 matrix x=@unvec(@range(1,9),3) 'create a 2X...

Dear Eviews team, I use Eviews 13 Oct 2022 build. Eviews breaks down, when saving a table with merged cells to Excel. This bug seems to happen only when there are no cell entries right of the merged columns (see example code below). wfcreate u 1 1 table tab tab(1,1)="C1" tab(1,2)="C2&...