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