Include the date as a column of a matrix

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Moderator, EViews Jason

DBel2012
Posts: 69
Joined: Sun Sep 30, 2012 5:37 am

Include the date as a column of a matrix

Postby DBel2012 » Mon Oct 28, 2013 5:57 am

Good morning,

I'm using Eviews 7

I've got a program that creates a matrix from a group of quarterly time series.

I need to include the date (ex. 2000Q1 or 20001) along with the series.

I know how to include the year (@year) and the quarter (@quarter) in two separate colums, but I can't figure out how to include the date in one column.

Any idea how (or if) that could be done?

Thanks!

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

Re: Include the date as a column of a matrix

Postby EViews Gareth » Mon Oct 28, 2013 8:04 am

Include @date

DBel2012
Posts: 69
Joined: Sun Sep 30, 2012 5:37 am

Re: Include the date as a column of a matrix

Postby DBel2012 » Mon Oct 28, 2013 8:22 am

Hi Gareth,

I've tried @date, but I got the following date format : 1/1/2000 instead 2000Q1.

Is there something else I should add?

Thanks!

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

Re: Include the date as a column of a matrix

Postby EViews Gareth » Mon Oct 28, 2013 8:47 am

I don't understand what you mean. A matrix can't show either of those date formats.

DBel2012
Posts: 69
Joined: Sun Sep 30, 2012 5:37 am

Re: Include the date as a column of a matrix

Postby DBel2012 » Mon Oct 28, 2013 9:09 am

Hi Gare

Finally, I was able to come up with a way of creating the kind of numeric date I was looking for using this set of commands :

@val(@strdate("YYYY.Q"))

Thanks!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 2 guests