Drop week days?

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

AfonsoRod
Posts: 43
Joined: Wed May 31, 2017 7:37 am

Drop week days?

Postby AfonsoRod » Tue Feb 26, 2019 8:20 am

Dear all,

I am working on an hourly data-set from 01-Jan-2009 until 31-12-2018. Initially i was working with all 7 days of the week, but now I wanted to see the results when only using the 5 week days (i.e. droping Saturday and Sunday).

So, my question is if there is any way of doing that with an Eviews command or if I am going to need to edit my Excel spreadsheet.

I thank you all in advance for the help.

Yours sincerely,
Afonso Rodrigues

AfonsoRod
Posts: 43
Joined: Wed May 31, 2017 7:37 am

Re: Drop week days?

Postby AfonsoRod » Tue Feb 26, 2019 9:07 am

After some navigation through Eviews buttons I figured out how to do it.

If anyone is interested you just need to click "proc" - "Structure/Resize Current Page...". Then you just need to change the days to 1 till 5, and Eviews will automatically delete all observations of Saturday and Sunday.

Sem Título.jpg
Sem Título.jpg (62.24 KiB) Viewed 3331 times


Sem Título2.jpg
Sem Título2.jpg (65.27 KiB) Viewed 3331 times


I hope I have helped some of you.

Yours sincerely
Afonso Rodrigues

EViews Matt
EViews Developer
Posts: 563
Joined: Thu Apr 25, 2013 7:48 pm

Re: Drop week days?

Postby EViews Matt » Tue Feb 26, 2019 10:05 am

Hello,

Depending on what you're ultimately doing with your data, you could alternatively adjust the sample to exclude Saturdays and Sundays. For example,

Code: Select all

smpl if @weekday < 6


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 27 guests