search for: can1540164

...individual ID (country name Abbreviation followed by an integer numbers) may have observation in several countries. Then the ID was changed by adding the country code as a prefix and new ID was constructed or recorded like (country code, + the original unique ID Example original ID "CAN1540164" , if this ID has an observation in CANADA then the ID was changed to "1CAN1540164". From this new ID I want get out the country code get the original unique ID and summarize the data by unique ID and country code The data set look like mydata <- read.table(textConnecti...

...d not give me that table. 2. I want select those unique Ids that do have records in all countries. From the above data set, this ID "FIN1540166" should be excluded from the summary table and the table looks like as follow IDNum Country 1 33 358 44 Sum CAN1540164 47 141 248 90 526 USA1540165 290 757 321 171 1539 Sum 337 898 569 261 2065 Thank you again On Fri, Feb 2, 2018 at 11:26 PM, Rui Barradas <ruipbarradas at sapo.pt> wrote: > Hello, > > Thanks for the reproducible example. > See if the following does wha...

...try name Abbreviation followed by an integer > numbers) may have observation in several countries. Then the ID was > changed by adding the country code as a prefix and new ID was constructed > or recorded like (country code, + the original unique ID Example > original ID "CAN1540164" , if this ID has an observation in CANADA then > the ID was changed to "1CAN1540164". From this new ID I want get out > the country code get the original unique ID and summarize the data by > unique ID and country code > > The data set look like > mydata...

...hose unique Ids that do have records in all >> countries. >> From the above data set, this ID "FIN1540166" should be >> excluded from the summary table and the table looks like as follow >> >> IDNum Country 1 33 358 44 Sum CAN1540164 47 141 248 90 526 >> USA1540165 290 757 321 171 1539 Sum 337 898 569 261 2065 >> >> Thank you again >> >> >> On Fri, Feb 2, 2018 at 11:26 PM, Rui Barradas >> <ruipbarradas at sapo.pt <mailto:ruipbarradas at sapo.pt>...