Re: [Gretl-users] ODS importer
On Thu, 8 Nov 2007, John C Frain wrote:
Thanks for so quick a solution. I have tried and can confirm that
the
ods importer now respects the dates in the ods file. I think that
what you are doing is probably what most people will want. In
Rmetrics it is possible to strip the NAs from a daily series (all 5
days per week) and retain what you are proposing. It is also possible
to add back in the na's to the reduced series to recover the original
5-day per week series with missing values. I have used this facility
to then interpolate for the missing values.
I've been thinking about something along those lines. More on that
later.
I have also had a look at adding data cells containing =NA() (or
#N/A) opposite the holiday dates in the ods file. These are
imported into gretl as 0.
Ah, that's because such cells contain the numeric value 0
internally -- but the text "#N/A" is also stored internally, so we
ought to recognize that. Fixed in CVS.
If I replace the =NA() by any string such as NA then that is
also imported as 0.
Gretl should now recognize the strings
NA, N.A, n.a, N/A, NaN, . and ..
as missing values.
If I just enter the date in the first
column and leave the data entries blank they appear as blank in
gretl's | data | display values | and I presume are then treated
as missing by gretl.
Yes, that's right.
Allin.