I have 150 instances in my database of 100,000 records where 2 records reported during the same 1 minute (where "obs_min=0" and both have the same values for min=47 and date=331.366) and I would like to keep the record for the first location (outdoors in the sample data below) and delete the one with the second location (Embassy below).. I am using Stata 17.
IDnum Session TimeActivity min date PM25 obs_min
5 1 Outdoors 44 331.3639 61 1
5 1 Outdoors 45 331.3646 74 1
5 1 Outdoors 46 331.3653 51.5 1
5 1 Embassy 47 331.366 0 1
5 1 Outdoors 47 331.366 4 0
5 1 Embassy 48 331.3667 0 1
5 1 Embassy 49 331.3674 0 1
5 1 Embassy 50 331.368 0 1
IDnum Session TimeActivity min date PM25 obs_min
5 1 Outdoors 44 331.3639 61 1
5 1 Outdoors 45 331.3646 74 1
5 1 Outdoors 46 331.3653 51.5 1
5 1 Embassy 47 331.366 0 1
5 1 Outdoors 47 331.366 4 0
5 1 Embassy 48 331.3667 0 1
5 1 Embassy 49 331.3674 0 1
5 1 Embassy 50 331.368 0 1