convert Date series into Series indicating Year/Quarter

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

centroid
Posts: 20
Joined: Fri Feb 05, 2021 4:46 am

convert Date series into Series indicating Year/Quarter

Postby centroid » Fri May 05, 2023 1:58 am

I would like to turn a Series containing dates in the format yyyy-mm-dd(as an example "2023-05-05") into a series of Years-Quarters in the format yyyyQq (as an example "2023Q2"). How can I do this?

I tried different things, but with no success.

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

Re: convert Date series into Series indicating Year/Quarter

Postby EViews Gareth » Fri May 05, 2023 5:02 am

Alpha mydate = @datestr(dateseries, “YYYY[Q]q”)
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 17 guests