Re: [Gretl-users] csv date parsing
On Wed, 19 Nov 2008, Sven Schreiber wrote:
Am 19.11.2008 17:56, Sven Schreiber schrieb:
>
> Even after naming the first column 'obs', still it doesn't work! Could
> it be that the problem is that my data is stored in reverse
> chronological order (t=T at the top, t=1 at the bottom)?
replying to myself: this indeed seems to be the problem. I imported the
csv file into OpenOffice without problems, and there I could easily
change the sorting to chronological order (instead of reverse). Then I
exported the file to csv again, with the dates in the format YYYY-MM-DD.
That new csv file could be easily imported into gretl.
Bottom line: IMHO gretl's import mechanism should also allow reverse
chronological ordering, which at present apparently it doesn't.
It doesn't, but it's easy enough to reverse the data in gretl (as
in the Cheatsheet chapter of the manual):
genr sortkey = -obs
dataset sortby sortkey
However, I'll take a look at auto-reversing.
Allin.