Exclude Mondays From Sample

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

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

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 7:07 am

Then how are there 743 observations in a 4 or 5 month period?
Follow us on Twitter @IHSEViews

ecofin
Posts: 182
Joined: Fri May 10, 2013 11:24 am

Re: Exclude Mondays From Sample

Postby ecofin » Sat Apr 16, 2016 7:27 am

ok, how can exclude interval date from daily and monthly and weekly frequency?
for daily i have used: smpl if @during(" 1/01/2003 6/6/2003")
for monthly: smpl if @during(" 2003m1 2003m6")
for weekly: smpl if @during(" 1/01/2003 4/6/2003")
but all this doesn't work

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 7:29 am

Ah, sorry, I am being dim (and I am on my phone only which makes it harder to read)

Smpl if @during(stuff)<>1
Follow us on Twitter @IHSEViews

ecofin
Posts: 182
Joined: Fri May 10, 2013 11:24 am

Re: Exclude Mondays From Sample

Postby ecofin » Sat Apr 16, 2016 7:54 am

sorry!, for the weekday doesnt work i have 143 obs range when i use this: smpl if @during(" 1/01/2003 4/6/2003") i get 23 obs (143-23=120), with the code smpl if @during(" 1/01/2003 4/6/2003")<>1 i get 121 obs.

ecofin
Posts: 182
Joined: Fri May 10, 2013 11:24 am

Re: Exclude Mondays From Sample

Postby ecofin » Sat Apr 16, 2016 9:16 am

why i get 121 obs for the weekday.
Attachments
ts_model.wf1
(47.12 KiB) Downloaded 226 times

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 9:26 am

Type:

Code: Select all

show @during(" 1/01/2003 4/6/2003")
Follow us on Twitter @IHSEViews

ecofin
Posts: 182
Joined: Fri May 10, 2013 11:24 am

Re: Exclude Mondays From Sample

Postby ecofin » Sat Apr 16, 2016 9:55 am

the value 0.142857 at the last of smpl, or because the frequency weekday cause this, i can solve this by smpl if @date>@dateval("04/06/2003") because i have one interval in the beginning of smpl.
but the problem when we have mult interval to exclude from smpl with the weekday frequency :?: smpl if @during("date1 date2")<>....@during("date1 date2")<>...
how can solve this?

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 10:12 am

First off I'm not really sure what you mean by "weekday".

Assuming you mean "weekly" how do you want to handle the case where your cutoff dates are in the middle of the week?
Follow us on Twitter @IHSEViews

ecofin
Posts: 182
Joined: Fri May 10, 2013 11:24 am

Re: Exclude Mondays From Sample

Postby ecofin » Sat Apr 16, 2016 10:30 am

Got it!, :)
smpl if @during("1/01/2003 10/6/2003")<>1
thanks for your help.

magister
Posts: 16
Joined: Tue Mar 08, 2016 4:14 pm

Re: Exclude Mondays From Sample

Postby magister » Tue May 17, 2016 5:04 am

Hi,

How can I exclude from my sample, consisting of daily data, Tuesdays, Wednesdays and Thursdays? I have tried smpl if @weekday=1 and @weekday=5 and smpl if @weekday<>2 and @weekday<>3 and @weekday<>4, but it does not work.

Thank you.

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Tue May 17, 2016 5:45 am

Code: Select all

smpl if @weekday=1 or @weekday=5
Follow us on Twitter @IHSEViews

magister
Posts: 16
Joined: Tue Mar 08, 2016 4:14 pm

Re: Exclude Mondays From Sample

Postby magister » Tue May 17, 2016 6:14 am

EViews Gareth wrote:

Code: Select all

smpl if @weekday=1 or @weekday=5

Thank you!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 37 guests