[Gretl-users] Re: "join"two gdt panel data files (B) save them as time series

Am 07.06.2022 um 18:28 schrieb Ioannis Venetis: > Hello all, Hi Ioannis, > > I attach two gdt panel data files (is what I managed to do, TIME is a > time index, GEO lists 38 countries/regions, and two variables CP00, CP01), > > example1.gdt goes from 2016:01-2018:12 and > example2.gdt goes from 2019:01-2022:04 Actually it seems to be the other way around. > (A) is there an "easy" way to "join" the two gdt files into one > time-larger file? running from 2016:01:-2022:04? I think the trick here would be to first extend the time dimension of the earlier dataset (example2) to cover everything up to 2022, being empty until the actual appending is done. (menu Data/Add observations) Simple appending still doesn't seem to work then (maybe it should), but you can use the graphical join option, then in the dialog window specify "TIME" and "GEO" as the keys to be matched. In the GUI right now you have to do that separately for each variable, I'm afraid. (In a script it's easier for multiple variables, but here you only have two.) Hope that explanation was clear.