Announcement

Collapse
No announcement yet.
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Keep one record and delete another?

    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


    Last edited by Leslie Edwards; 07 Feb 2022, 18:53.
Working...
X