Hi, I think that the name of the Date field is missing (there are some rules for Gretl recognize CSV as time series).
Good luck. Helio Date,shillerRet,state,consSentiment,PMI On Thu, Jan 3, 2013 at 4:03 PM, Grześ Andruszkiewicz <gandrusz(a)gmail.com> wrote: > Hi, > > As in the documentation, I am trying to import data to gretl from a csv > file. > The data is monthly, so it looks something like this: > ,shillerRet,state,consSentiment,PMI > 1987:02,0.0045773162,1,90.4,54.9 > 1987:03,0.004080661,1,90.2,52.6 > 1987:04,0.0045113495,1,90.8,55 > 1987:05,0.0050701111,1,92.8,55.5 > 1987:06,0.004516603,1,91.1,57.2 > (...) > > but gretl fails to interpret is as timeseries data: > parsing /home/ga1009/PhD/cpp/pmi/gretlInput.csv... > using delimiter ',' > longest line: 43 characters > number of columns = 5 > number of variables: 4 > number of non-blank lines: 297 > scanning for variable names... > line: ,shillerRet,state,consSentiment,PMI > scanning for row labels and data... > the cell for variable 3, obs 294 is empty: treating as missing value > the cell for variable 3, obs 295 is empty: treating as missing value > the cell for variable 3, obs 296 is empty: treating as missing value > first row label "1987:02", last label "2011:09" > trying to parse row labels as dates... > 1987: probably a year... month 02? > 1987:01: not a consistent date > but the dates are not complete and consistent > treating these as undated data > > Am I doing something wrong? > > Regards, > Grzegorz > > > _______________________________________________ > Gretl-users mailing list > Gretl-users(a)lists.wfu.edu > http://lists.wfu.edu/mailman/listinfo/gretl-users
