generate trend between two date

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 9:50 am

Hi everybody,
how can generate trend between two date, for dummy it's easy by @during("date1 date2"), i have combined @trend(@during("date1 date2")) but no idea.
i have 400 obs monthly to generate some broken trend and levelshift, each time i use smpl date1 date2, are there any way to do this.
best regards.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 9:52 am

Need more details.

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 10:01 am

for example: generate trend between 1990m01 and 1997m06 for monthly ( trend take 1 2 3.....and so on)
and for weekly data 01/01/1990 to 09/06/1997.
Last edited by ch2324 on Wed Feb 24, 2016 10:08 am, edited 1 time in total.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 10:06 am

Code: Select all

smpl 1990m1 1997m6 series trend=@trend+@dtoo("1990m1")

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 10:14 am

error message: @dtoo is not genr or series expression function.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 10:28 am

Code: Select all

smpl 1990m1 1997m6 !offset = @dtoo("1990m1") series trend=@trend-!offset+1

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 10:31 am

error message: !offset is not defined

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 10:36 am

run it in a program.

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 10:45 am

it run but the othres value take NA value, i need this
from 1988m01 to 1989m12 take 0,
from 1990m01 to 1997m06 take trend
from 1997m07 to 2003m12 take 0.
you understood me now.
i have others case to generate but it take long time to make smpl date1 date2, @during it's very easy to do dummy.

startz
Non-normality and collinearity are NOT problems!
Posts: 3797
Joined: Wed Sep 17, 2008 2:25 pm

Re: generate trend between two date

Postby startz » Wed Feb 24, 2016 11:03 am

series t = 0
smpl 1990m01 1997m06
t = @trend("1990m01")+1
smpl @all

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 11:13 am

or

Code: Select all

series t = @recode(@during("1990 1997m6"), @trend, 0)

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 12:55 pm

thanks Mr Gareth and Mr startz.
1)suppose i would like to have trend between 1990m1 to 1997m6 and between 2000m1 2002m12, i have used this code but it not work.

Code: Select all

series t = @recode(@during("1990m1 1997m6"), @trend, 0) and @recode(@during("2000m1 2002m12"), @trend, 0)
Last edited by ch2324 on Wed Feb 24, 2016 1:01 pm, edited 2 times in total.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 1:00 pm

Code: Select all

series t = @recode(@during("1990m1 1997m6") or @during("2000m1 2002m12"), @trend, 0)

ch2324
Posts: 133
Joined: Fri May 10, 2013 10:52 am

Re: generate trend between two date

Postby ch2324 » Wed Feb 24, 2016 1:02 pm

another question :oops:
generate trend:
the 1st year take trend
the 2nd year take 0
the 3rd year take trend
the 4th take 0.....and so on.

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13603
Joined: Tue Sep 16, 2008 5:38 pm

Re: generate trend between two date

Postby EViews Gareth » Wed Feb 24, 2016 1:05 pm

Code: Select all

series t = @recode(@mod(@trend,2)=0, @trend, 0)


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests