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

kroonike
Posts: 1
Joined: Sun May 03, 2015 4:29 am

Exclude Mondays From Sample

Postby kroonike » Sun May 03, 2015 4:37 am

Hello,
I'm just learning how to use Eviews and have a newbie question. I've imported 14 years of daily panel data, and would like only to analyse the datapoints from Tuesdays to Fridays (excluding Mondays). I believe it is done through "sample" option, but I wasn't able to find any information on how to include only specific days of the week.

Vitali

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sun May 03, 2015 11:08 am

Follow us on Twitter @IHSEViews

Marcel Visser
Posts: 5
Joined: Mon May 18, 2015 3:51 am

Re: Exclude Mondays From Sample

Postby Marcel Visser » Tue May 19, 2015 8:27 am

I have got a similar question, I have two work files, one with panel data and one with unstructured data. In both of these data sets I would like to create two samples. One in which my dummy variable equals 1 and another in which my dummy variable equals 0. The reason for this is that i would like to get separate regression outputs for multinationals, dm 1, and domestic companies, dm 0. I have tried (smpl if @dm=1), (smpl @dm=1), (smpl if @dm>0) and (smpl @dm>0). Non of the work. What am i doing wrong?

I would like to thank you in advance for your help.

Marcel Visser

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Tue May 19, 2015 8:43 am

Follow us on Twitter @IHSEViews

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

Re: Exclude Mondays From Sample

Postby magister » Wed Apr 13, 2016 7:35 am

How can I remove a specific date/dates from a sample? I've tried smpl if @date <>"specific date/s", smpl if @day <>"specific date/" (in the case of daily data), but it does not work. Also, I've tried to make 2 sub-sample: @first specific date-1 specific date +1 @last, but GARCH models require a continous sample.

Thank you.

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Wed Apr 13, 2016 9:07 am

How did you enter the specific dates?

GARCH does require a continuous sample.
Follow us on Twitter @IHSEViews

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

Re: Exclude Mondays From Sample

Postby magister » Thu Apr 14, 2016 3:02 am

EViews Gareth wrote:How did you enter the specific dates?

GARCH does require a continuous sample.


Do you mean the format which I have entered the date? It's MM/DD/YYYY format.

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Thu Apr 14, 2016 6:32 am

You need to do:

Code: Select all

smpl if @date<>@dateval("mydate")
Follow us on Twitter @IHSEViews

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

Re: Exclude Mondays From Sample

Postby magister » Thu Apr 14, 2016 2:14 pm

EViews Gareth wrote:You need to do:

Code: Select all

smpl if @date<>@dateval("mydate")


And for multiple dates?

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Thu Apr 14, 2016 7:16 pm

Code: Select all

smpl if @date<>@dateval("mydate") and @date<>@dateval("myotherdata")
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 3:58 am

hi,
supose i would excluse an interval date from the range, for example from 2/01/2003 to 6/6/2003, i have use this: smpl if @date<>@during("2/01/2003 6/6/2003") but doesn't work.

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 4:34 am

You don't need the @date<> bit
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 4:39 am

but when i use smpl if @during(" 2/01/2003 6/6/2003") i get 257 obs, i have 1000 obs in the range it should be 743 obs in smpl

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

Re: Exclude Mondays From Sample

Postby EViews Gareth » Sat Apr 16, 2016 5:37 am

What is the frequency?
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 6:59 am

i have three frequency in the three page, daily 7 day, monthly frequency (2nd page), and weekly in 3rd page.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 25 guests