I have a dataset which has a number of variables including NAME. I am trying to delete duplicate observations of name where one observation would be 'John Smith' and another observation would be 'smith john' .. they are clearly the same person and i want to delete the duplicate entry .. what would be the most efficient way to do it ? considering also that the duplicate names could occur anywhere within the dataset.   Ex: John Smith Cal Harper freddy Holt smith john frank waters harper Cal ... View more

guys ...  stuck on a small basic problem ..  need to write to a file but using values from subsequent observations ..  the attached image explains the issue .. please help with code to replace "????????" part ..   thanks  ... View more

so I have a huge dataset(millions of rows) with over 100 variables (and more get added regularly)  .. Each variable having a 2 digit value. For example:   C1 C2 C3 C4 C5 .. .. 10 12 15 55 15 .. .. 10 10 15 10 12 .. .. 10 10 10 10 10 .. .. 10 10 12 12 15 .. .. .. .. .. .. .. .. ..  .. .. .. .. .. .. ..   Now I want to make and populate a result variable which basically read each row and outputs the value that has the most occurrences. For example:   C1 C2 C3 C4 C5 .. .. RESULT 10 12 15 55 15 .. ..   15 10 10 15 10 12 .. ..   10 10 10 10 10 10 .. ..   10 10 10 12 12 15 .. ..   12 (higher value in case of a tie) .. .. .. .. .. .. ..  .. .. .. .. .. .. ..   What would be the most efficient code to write for this allowing for the possibility of more test columns(with values) to be added to the dataset.   Thanks in advance !!! ... View more