Re: [Gretl-users] WG: append horizontal and vertical

On Thu, 21 Sep 2017, Schaff, Frederik wrote: Frederik is referring to my script to do his data concatenation job using the (recently tweaked) "append" command; see http://lists.wfu.edu/pipermail/gretl-users/2017-September/012690.html for details. I see what the problem is. First, there was a residual issue with the "append" command, which I have now fixed in git. But beyond that, I was assuming a greater regularity in Frederik's data files than actually obtains. The following comment will mean little to anyone who hasn't tried working with Frederik's data, but here goes... My assumption was that the per-observation files stat_0-499_1.tsv stat_0-499_2.tsv stat_0-499_3.tsv (and other such tuples) contained observations (1,2,3) on a common set of variables. Mostly that does seem to be the case -- and if it were always the case my "append" recipe should work -- but it's not always the case. In particular the file stat_0-499_3.tsv contains three variable identifiers that are not found in any other file, namely Attendance_L_cv_I1 Attendance_L_Skew_I1 Attendance_L_Kurt_I1 This discrepancy means the "append" (a fairly simple-minded command) will not do the job; the other options are "join", as Jack showed in http://lists.wfu.edu/pipermail/gretl-users/2017-September/012686.html or handling the data as matrices, as I showed in http://lists.wfu.edu/pipermail/gretl-users/2017-September/012683.html (Jack's suggestion was subject to Windows bug which has now been fixed.) Allin