I am working with a large data set and trying to figure out how I can create a code where the specimen number meets 2 criteria: Report Status = "CORRECTIVE" and "FINAL" while also keeping all variables in the table: This is the dataset I have: Record ID Specimen number Date Collected Report Status 12345 W2345678 1/5/2020 Corrective Final 23456 M9876799 3/4/2023 Corrective 84569 N45678987 5/22/2022 Corrective Final 78766 P73839303 6/9/2022 Final 35473 R37390202 4/7/2023 Corrective This is what I want: Record ID Specimen number Date Collected Report Status 12345 W2345678 1/5/2020 Corrective Final 84569 N45678987 5/22/2022 Corrective Final I also want to create a code where the specimen number has a Report Status as Corrective only but was never Final. Can anyone help me with this? Thank you so much!
... View more