Hi Guys, I need to select the first date of a 2 variables combinations. For example: data: number | pet | date 1 dog  12.11.2018 1 dog 18.6.2019 1 cat 1.1.2016 1 cat 6.3.2015 1 fish  2.2.2016   result wanted: 1 dog  12.11.2018 1 cat 6.3.2015 1 fish  2.2.2016   Please help, Thank you! ... View more

Hi,    I'm trying to calculate new variables based on other variables from different row of specific value.  For example:    my_data: name string value name string value aba aaaaa 12 baba bbbbb 84 caca cccc 65 gaga ddddd 52     wanted_data name  string value diff aba aaaaa 12   baba bbbbb 84 72 caca cccc 65 44 gaga ddddd 52 40   The calculation of the new variable diff: 0 84-12 65-12 52-12   Please advice, Thank you! ... View more

Hi Guys,  I need to merge two datasets by a variable that is included in other variable in the second dataset. for example:    dataset#1 names data ABLIM1 ABLIM KIAA0059 LIMAB1 data1  AK3 AK3L1 AK6 AKL3L data2 AK4 AK3 AK3L1 data3 ADD3 ADDL data4 PHYKPL AGXT2L2 PP9286 data5     dataset#2 name more data ABLIM more data 1 ADDL more data 2 DKG more data 3 PRWR more data 4       The result I need: name names data more data ABLIM ABLIM1 ABLIM KIAA0059 LIMAB1 data1  more data 1 ADDL ADD3 ADDL data4 more data 2 DKG     more data 3 PRWR     more data 4     Thank you! ... View more