Re: [Gretl-users] csv date parsing
Am 19.11.2008 23:08, Allin Cottrell schrieb:
On Wed, 19 Nov 2008, Sven Schreiber wrote:
>
> 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
This by itself is already interesting, and although I had checked the
relevant chapter of the guide, I didn't look in the cheatsheet chapter.
Thanks for the pointer. One follow-up question here: would 'dataset
sortby -obs' also work, or is the genr line necessary?
Anyway, even after reversing the data it still is the case that the
dates were not recognized, and that information would have to be entered
manually. So in that sense I think my detour via Openoffice is still
better than the gretl-only workaround. But that is a matter of taste I
guess.
However, I'll take a look at auto-reversing.
Thanks, that would be quite useful. And it seems to me that in a
situation where gretl is already capable of interpreting the date
strings correctly, then ordering the data internally shouldn't be such a
big problem, no?
thanks,
sven