I have data from a survey where some participants opened the survey twice, thrice or more. How do I drop the data for the second and onwards entries regardless of whether they completed the survey or not at a go for any entry. I want to only keep the first observation. These participants are identified by the ID number, var(id). So
In this case, I would want to drop the third and fourth rows because the share the same ID number as row 1.
Please let me know, thank so much in advance!
id | surveyprogress% |
1 | 23 |
1 | 12 |
1 | 56 |
2 | 13 |
Please let me know, thank so much in advance!
Comment