How to create month dummy variable automatically?

[gansuld]

I have a variable with name which includes year, month, day, but these three (year, month, day) are just one category. In that case, how to create month dummy variable automatically? What more, my variable takes the values of 2013-01-13, 2014-01-13, and so on. Hence, I am only interested month dummy variable.

[EViews Gareth]

Is your work file structured by that variable?

[gansuld]

My data is pooled cross section. I mean, my data is by month in 2013, 2014. I have entered the data in Eviews as unstructured working file.

[EViews Gareth]

Post the workfike

[gansuld]

It is my working file.

[gansuld]

I have 17 months. I want to create month dummy variables automatically using date?

[startz]

Code: Select all

series month=@datepart(date,"mm") series d1=month=1

[gansuld]

Thank you very much. I used this command. However, I have one problem. I created the variable is d1, but for the d1, "2013-01" and "2014-01" are the same values. In my case, 2013-01 and 2014-01 are different values. I mean 2014-01 should equal to 13, 2014-02 should equal to 14, and so on. Help me...

[startz]

Something like

Code: Select all

series month=@datepart(date,"mm") series year=@datepart(date,"yyyy") series distinctMonth = month+ year-2013 series d1=distinctMonth =1

[gansuld]

Thanks a million!!! Again, I have one question. How to change a value of variable in eviews automatically?