How to sort and select data while preserving the date

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

LVP
Posts: 2
Joined: Wed Mar 07, 2018 11:02 pm

How to sort and select data while preserving the date

Postby LVP » Sat Feb 16, 2019 10:00 pm

I would like to sort a time series and extract the 5% and 95% percentile of the observations while I keep the corresponding date (in a date format not the equivalent number)
After using @capplyranks I got a matrix where the first column is the numeric value of the date and the second column is the series. I want to transform the numeric value in first column into a date format at the same time I keep the series in the 2nd column.
Any idea how to proceed?
Thanks.

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

Re: How to sort and select data while preserving the date

Postby EViews Gareth » Sun Feb 17, 2019 8:56 am

What do you want to do with the matrix?
Follow us on Twitter @IHSEViews


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 24 guests