changing obs label from numbers to dates

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

vogelh
Posts: 33
Joined: Mon May 21, 2012 2:27 pm

changing obs label from numbers to dates

Postby vogelh » Mon Jul 17, 2017 12:13 pm

v9.5
Got a graph that generates line correctly, but there are 17,000 daily data points on x-axis. Having trouble changing the point numbers into observation dates. Have done this before, but somehow cannot get this to work now.
What would be the best way to convert to dates. Data runs from Jan 3, 1950 to July 11, 2017.

Thanks.

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

Re: changing obs label from numbers to dates

Postby EViews Gareth » Mon Jul 17, 2017 12:14 pm

Is the workfile dated?
Follow us on Twitter @IHSEViews

vogelh
Posts: 33
Joined: Mon May 21, 2012 2:27 pm

Re: changing obs label from numbers to dates

Postby vogelh » Mon Jul 17, 2017 12:19 pm

here's a screen shot I'm using 750 as !ssize
Range:1/03/1950-7/12/2017
Sample: 8/27/2014 7/11/2017

Dependent Variable: SER04
Method: ARMA Maximum Likelihood (BFGS)
Date: 07/17/17 Time: 15:17
Sample: 8/27/2014 2/16/2015
Included observations: 124
Convergence achieved after 5 iterations
Coefficient covariance computed using outer product of gradients

Variable Coefficient Std. Error t-Statistic Prob.

C 9.658535 44.57378 0.216686 0.8288
SER03 0.995401 0.018784 52.99110 0.0000
AR(1) -0.168267 0.095990 -1.752962 0.0822
SIGMASQ 107.2947 8.996658 11.92607 0.0000

R-squared 0.956006 Mean dependent var 2370.496
Adjusted R-squared 0.954906 S.D. dependent var 49.58510
S.E. of regression 10.52954 Akaike info criterion 7.578205
Sum squared resid 13304.55 Schwarz criterion 7.669181
Log likelihood -465.8487 Hannan-Quinn criter. 7.615161
F-statistic 869.2166 Durbin-Watson stat 2.020548
Prob(F-statistic) 0.000000

Inverted AR Roots -.17

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

changing obs label from numbers to dates

Postby EViews Gareth » Mon Jul 17, 2017 12:40 pm

That appears to be equation output
Follow us on Twitter @IHSEViews

vogelh
Posts: 33
Joined: Mon May 21, 2012 2:27 pm

Re: changing obs label from numbers to dates

Postby vogelh » Mon Jul 17, 2017 1:42 pm

My graph output is in attached .wf1

Hope you can open it.
Only thing I can't figure out is how to change to observation dates.

Thanks.
Attachments
results screenview.WF1
(910.52 KiB) Downloaded 261 times

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

Re: changing obs label from numbers to dates

Postby EViews Gareth » Mon Jul 17, 2017 3:57 pm

I assume you're talking about the matrix object, results.

Matrices do not have dates or a time dimension.

You'll have to convert it to series. You can use the mtos command for that.
Follow us on Twitter @IHSEViews

vogelh
Posts: 33
Joined: Mon May 21, 2012 2:27 pm

Re: changing obs label from numbers to dates

Postby vogelh » Mon Jul 17, 2017 3:59 pm

Yes, using matrix called "results". Thanks for suggestion. Will try later today.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 10 guests