Series of formatted date strings

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

lgehrig
Posts: 15
Joined: Fri Mar 17, 2017 8:10 am

Series of formatted date strings

Postby lgehrig » Wed May 16, 2018 8:12 am

Hi EViews Pros

I have a huge confusion with date series.
I would like to have a series of DATES that I can add to my

Code: Select all

write() xx.csv DATES EXPORTVARIABLES

But instead of the date numbers (1999Q1, since I'm at quarterly frequency) I would like to control the date format, hence I cannot simply use the "dates" argument in the write function.

Code: Select all

series dates=@date


supposedly gives me date numbers, but I cannot change the date format on the entire series using @datestr.

Code: Select all

@strdate("dd.mm.yyyy")


doesn't do what I'd like to get either.

Can anyone push me in the right direction here? Thanks a lot!

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

Re: Series of formatted date strings

Postby EViews Gareth » Wed May 16, 2018 8:23 am

Create an alpha series in the workfile containing the string representation of the date you want to use.

Code: Select all

alpha mydates = @datestr(@date, "YYYY[Q]Q")
Follow us on Twitter @IHSEViews

lgehrig
Posts: 15
Joined: Fri Mar 17, 2017 8:10 am

Re: Series of formatted date strings

Postby lgehrig » Wed May 16, 2018 11:36 pm

Aha! That makes sense. Thanks, Gareth!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 6 guests