generate date

[metrix]

I ask this question because EViews can not suport this frequency by four month.
1/i have workfile with two page with monthly frequency 1998m01 2010m12 (156 obs), and undated (156/4)=39 obs, how can generate date by every four month in the page unstructured (30/04/1998, 31/08/1998,....), or by simple question how can moved the the undated page to import just this date and make the mean of my series salaries by every 4 month.

30/04/1998
31/08/1998
31/12/1998
30/04/1999
31/08/1999
31/12/1999
....
31/12/2010
2/ it is possibale the generate date weeks in undated page: 02/01/1998, 09/01/1998, 16/01/1998,....
3/I have no seen in all software a frequency "by four month (1/3)" it's possible to include a new frequency by every fourth month (One third of the year 1/3) with function @thirdly, it is very nice to analyse some data economics with several frequency.
Thank you for what you realize for us.

[EViews Gareth]

1) On the monthly page create a series equal to @floor(@trend/4). On the undated page create a series equal to @trend. Then do a general match merge based on those series.

2) Something like:

Code: Select all

smpl @first @first
series weeks = @dateval("02/01/1998")
smpl @first+1 @last
weeks = @dateadd(weeks(-1), 1,"w")


[metrix]

1/ perfect thanks!
2/ for weeks ok!, but for month i get this: 30/08/1998, 30/12/1998, Aug and Dec have 31 days not 30
smpl @first @first
series months = @dateval("30/04/1998")
smpl @first+1 @last
months = @dateadd(months(-1), 4,"m")

[metrix]

When i do a general match merge, my series date will be like this in page undated: 1998-02-15 00:00, 1998-06-16 00:00, 1998-10-16 12:00, 1999-02-15 00:00.... but i need this:

30/04/1998
31/08/1998
31/12/1998
30/04/1999
....
31/12/2010

or 1998m04, 1998m08, 1998m12....

[EViews Gareth]

1/ perfect thanks!
2/ for weeks ok!, but for month i get this: 30/08/1998, 30/12/1998, Aug and Dec have 31 days not 30
smpl @first @first
series months = @dateval("30/04/1998")
smpl @first+1 @last
months = @dateadd(months(-1), 4,"m")

So?

[metrix]

i get this with the code: 30/08/1998, 30/12/1998...., Aug and Dec have 31 days not 30.
how can modifiend this.

[EViews Gareth]

You told EViews to add a month to a date. The 30th of July plus a month is the 30th of August.

The 15th of a month plus a month is the 15th of the next month, whether or not the months have 30 days or 31 days.

[metrix]

Emmm , how can import just the last date by four month from my page frequency monthly.

[EViews Gareth]

You can find the date of the last day of the current month by adding a month (using @dateadd), getting the date floor (@datefloor) to give you the first date of the next month, then subtracting one.

[metrix]

i have use this: but i get not the date
series f=@date<=@datefloor(@date,"m")+1 or @dateadd(@datefloor(@date,"m"),3,"m")

[EViews Gareth]

What's the inequality for?

[metrix]

if i use series f=@datefloor(@date,"m") it generate all date, inequality is to use just the 1998m04 1998m08 1998m12... in the series, I don't know how.

[metrix]

How can solve my case? by @dateadd and @datefloor

[metrix]

i have use this Mr Gareth:

Code: Select all

series f=@dateadd(@datefloor(@date,"m"),3,"m")

could you help me.

[EViews Gareth]

Help you with what?