Search found 32 matches

by AfonsoRod
Tue Feb 26, 2019 9:07 am
Forum: Data Manipulation
Topic: Drop week days?
Replies: 2
Views: 312

Re: Drop week days?

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 Saturda...
by AfonsoRod
Tue Feb 26, 2019 8:20 am
Forum: Data Manipulation
Topic: Drop week days?
Replies: 2
Views: 312

Drop week days?

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 Ev...
by AfonsoRod
Wed Jan 30, 2019 3:46 am
Forum: Econometric Discussions
Topic: Regression model with hourly data?
Replies: 0
Views: 246

Regression model with hourly data?

Dear all I am a master students in Economics at Universidade da Beira Interior - Covilhã, Portugal , and I am (trying) to perform an econometric research paper for my master thesis. All this to say that I am new at econometrics and Eviews, so I will probably ask some basic or even dumb questions. If...
by AfonsoRod
Tue Jan 29, 2019 8:52 am
Forum: Econometric Discussions
Topic: Unit Root Tests with structural breaks
Replies: 1
Views: 269

Unit Root Tests with structural breaks

Dear all I have learned that due to the characteristics of some variables and the frequency of some data (for example, monthly) the system is subject to shocks. Thus, the traditional unit root tests (ADF, PP and KPSS) may show inappropriate results, due to the existence of structural breaks in the t...
by AfonsoRod
Wed Jan 23, 2019 3:57 am
Forum: Estimation
Topic: Dummies for day of the week, month and year
Replies: 6
Views: 604

Re: Dummies for day of the week, month and year

You can't give a series a name starting with a number. Call it Y2009 instead. Thank you, that worked. Regarding the "no reason to do this", if the day of the week, month or year can make variables to have a different behavior towards the dependent variable, isn't it a reason to this kind ...
by AfonsoRod
Tue Jan 22, 2019 12:46 pm
Forum: Estimation
Topic: Dummies for day of the week, month and year
Replies: 6
Views: 604

Re: Dummies for day of the week, month and year

If I use the same thing for years i get this error message "(1) is not a valid index for."

The code I used was:

Code: Select all

genr 2009=@year=2009
by AfonsoRod
Tue Jan 22, 2019 12:02 pm
Forum: Estimation
Topic: Dummies for day of the week, month and year
Replies: 6
Views: 604

Dummies for day of the week, month and year

Dear all I have a hourly data covering the period of 01/jan/2009 to 31/dec/2018, and I want to create dummies for each day of the week, each month and each year. For the day of the week and month dummies I have conducted the following codes with success: genr january=@month=1 genr monday=@weekday=1 ...
by AfonsoRod
Tue Jan 22, 2019 10:16 am
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Re: Import hourly data - workfile

Unfortunately not. You could create an alpha series containing the format you want (something like alpha a = @datestr(@date, "DD/MM/YYYY") + " " + @str(@hour+1)), then structure the workfile as undated by id series, where that alpha is the id series. But once you've done that, E...
by AfonsoRod
Tue Jan 22, 2019 10:09 am
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Re: Import hourly data - workfile

I'm not sure I follow the issue... It seems like EViews is putting the data in the correct place. Are you just worried about the labeling of the hours? The observation labeled as: 01/01/2009 00:00 Has a value of 0.801182 for series A. That observation is the time between midnight and 1am (00:00 and...
by AfonsoRod
Tue Jan 22, 2019 9:11 am
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Re: Import hourly data - workfile

EViews Gareth wrote:Could you provide an example excel file (over-write the data with random numbers if confidentiality is an issue).
by AfonsoRod
Tue Jan 22, 2019 3:41 am
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Re: Import hourly data - workfile

EViews Gareth wrote:Are you doing a "Dated read" import or a "Sequential read" import?

If dated, try doing sequential (assuming your file has the same number of rows as the workfile etc...)


I've tried to do a sequential read import but everything stays the same.
by AfonsoRod
Mon Jan 21, 2019 3:07 pm
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Re: Import hourly data - workfile

How are you doing the import? Dear Gareth Thanks for your answer. After creating the workfile I import my data going "import from file" and then chose my excel. I've tried to upload an excel with both the date and hour columns and other without those columns. Either way I can't manage to ...
by AfonsoRod
Mon Jan 21, 2019 11:20 am
Forum: Data Manipulation
Topic: Import hourly data - workfile
Replies: 10
Views: 611

Import hourly data - workfile

Dear all, I have a hourly data with values from 01-jan-2009 to 31-dec-2018, and I am facing some difficulties to import it correctly to Eviews 10. The topic of the data is energy, more precisely, electricity and one of the variables is the electricity price. So, my excel is something like this: evie...
by AfonsoRod
Fri Jan 05, 2018 10:13 am
Forum: Econometric Discussions
Topic: What model should I estimate\choose?
Replies: 0
Views: 501

What model should I estimate\choose?

Hello everyone. So, I am very new and therefore very green in the Econometric world. I'm also a master degree student in Economics and I need to perform an econometric paper for one of my classes. So, I'm trying to study what are the main determinants on the price of water to the consumers, in the c...
by AfonsoRod
Wed May 31, 2017 11:20 am
Forum: General Information and Tips and Tricks
Topic: Merge graphs
Replies: 3
Views: 1775

Re: Merge graphs

Antonyf27 wrote:another doubt.
how can I change the range of a Graph, after the GRAPH is ploted
TY for helping to merge GRAPH BTW :)


I think you just need to double click on the axis you want to change.

Go to advanced search