Re: [Gretl-users] JOIN function

Thank you for your replies. It is very helpful for me. The data I am working with contains sensitive information and I do not have the permission to share it, otherwise I would have sent a sample. The command worked but now I encountered another problem. The message is "data types not conformable for operation". Gretl asked for the aggregation option. But I do not want to aggregate. The right-hand variables have more than one match with the left-hand variables. The files contain both numerical and string variables that need to be matched (the count of matches is not helping). For example one column on the right-hand that needs to be matched to the left-hand through variable NUMBER (numerical variable) looks similar to this: TYPEOFCONTROL (name) type2 type2 type2 type3 type4 ... Is it possible through the JOIN function to get it in numerical form after matching, or they need to be numerical before matching? I need the exact variable to be "joined" to the left-hand. I know that Gretl transforms the categorical variables into numerical ones (that can later be transformed into dummies) when importing the data. Example: TYPEOFCONTROL (is it possible to get it sth like this after matching?) 1 1 1 2 3 /Andreea On Sat, Aug 3, 2013 at 4:56 PM, Allin Cottrell <cottrell(a)wfu.edu&gt; wrote: