I merge two tables one has some 380 observations&4 variables & other has 2580 obs & 6 varaibles. I need to combine these tables by only common variable. But that variable should have only those values that corresponds to the true value of another variable in the 1st table. But if I merge these two tables I get the output as what I wanted but the records of the first table gets repeated for the consecutive values for which it is null for the corresponding values in the second table.
This mite b little confusion- just to make it simple is there anyways to remove the consecutive duplicate records of the merged tables for only 3 consecutive variables.
I hope I made my point clear. It would be nice if someone can get me some solution.
Thanks in advance.