time (trend) for daily custom week 6 day per week

[clubmed]

i have 3 problem case:
the first: frequency daily (from 2001 to 2005) custom week 6 day per week (Days: 6-Sat; 4-Thu)
i have data representaion with frequency daily (from 2001 to 2005) custom week 5 day per week (Days: 6-Sat; 4-Thu), when i use the code series timeyear=@datepart(@date, "ddd") i get trend for every year that what i need :D , but the problem it generate 365 or 366 days for every year, but some years have 314 days and some years have 313 days in my case.
i would to generate time (trend) for every year like this:
year 2001: time 1... 313
year 2002: time 1... 313
year 2003: time 1... 313
year 2004: time 1...314
......etc
the second: frequency daily (from 2001 to 2005) custom week 6 day per week (Days: 6-Sat; 4-Thu)
i have the same problem with this code when i use series timeday=@day, it generate day for every month, but some month i have 27 days and some others 25 days in month....
i would to generate time (trend) for every month in year.
01/01/2001-31/12/2001: time 1 ...27
01/02/2001-28/02/2001: time 1 ...23
....etc
the third: frequency daily (from 2001 to 2005) custom week 6 day per week (Days: 6-Sat; 4-Thu)
i have use timeweek=@weekday but not work
i would to generate time (trend) like this
01/01/2001-06/01/2001: time 1...6
07/01/2001-13/01/2001: time 1...6
14/01/2001 -20/01/2001: time 1...6
21/01/2001 - 27/01/2001: time 1...6
28/01/2001 - 31/01/2001: time 1 2 3 4 (end of month)
for the next month Feb
01/02/2001-07/02/2001: time 1...6
...... etc
any idea about this.

[EViews Gareth]

I'm on my phone so can't give precise code, but the basic idea is that you would use a @recode with a condition testing whether the day of the year is equal to 1 or not. If it is equal to 1, return 0, otherwise return previous value plus 1.

Something like:

Code: Select all

Series timeyear = @datepart(@date,"ddd")=1,0,timeyear(-1)+1)

Same logic can be applied to others

[clubmed]

the code for timeyear work perfectly

Code: Select all

series timeyear = @recode(@datepart(@date,"ddd")=1,0,timeyear(-1)+1)

the two code: for day and weekday not work because i have some month start by number 02 (example: 02/06/2001 and 02/02/2002, 02/03/2002,......etc); so if my data for example start by 02/01/2001 or 04/01/2001 i can not applied all the codes for my three case.

Code: Select all

series timeday = @recode(@day=1,0,timeday(-1)+1) series timewday = @recode(@weekday=1,0,timewday(-1)+1)

[EViews Gareth]

Try using @month<>@month(-1) as the condition

[clubmed]

this code work for day:

Code: Select all

series timeday = @recode(@month<>@month(-1),0,timeday(-1)+1) smpl 01/01/2001 31/01/2001 timeday = @recode(@day=1,0,timeday(-1)+1) smpl @all

for weekday i have no idea?

[clubmed]

i have use this code but doesn't work for weekday
series timewday = @recode(@weekday<>@weekday(-1),0,timewday(-1)+1)
any idea about this.

[clubmed]

probably i'm not explained very well.
i need to make time (trend) for weekday in every month
01/01/2001-07/01/2001: time 1...6
08/01/2001-14/01/2001: time 1...6
15/01/2001 -21/01/2001: time 1...6
22/01/2001 - 28/01/2001: time 1...6
29/01/2001 - 31/01/2001: time 1 2 3 (end of month)
for the next month Feb
01/02/2001-07/02/2001: time 1...6
...and so on.

[EViews Gareth]

Try @mod(@day,7)=1 as the condition

[clubmed]

No, the time (trend) should stop at the end of every month and start for the next month and so on.
for example:
......
29/01/2001: time=1
30/01/2001:time= 2
31/01/2001: time=3 (end of month)
01/02/2001: time =1

[clubmed]

hi,
the two code not give me what i need, the time (trend) not stop at the end of every month it continue, any help please.
series timewday = @recode(@weekday=1,0,timewday(-1)+1)
series timewday = @recode(@mod(@day,7)=1,0,timewday(-1)+1)

Best Regards.

[clubmed]

I tried this code but doesn't get what i need
series timewday = @recode(@weekday<=6,0,timewday(-1)+1)
any help.

[EViews Gareth]

I'm failing to see what is wrong with:

Code: Select all

@recode(@mod(@day,7)=1,0,timewday(-1)+1)

[clubmed]

i have some month start by day number 02 (example: 02/06/2001 and 02/02/2002, 02/03/2002,......etc).

[clubmed]

the code work if the month start by day=1, but for day start by day=2 not work

[EViews Gareth]

series time = @recode(@month<>@month(-1), 0, @recode(time(-1)=5, 0, time(-1)+1))