Hello I currently have a very large data set, which contains multiple records per person. I need to keep these records separate, as each row contains different information. Each person has an ID number which is duplicated for each of their records. One variable within this data set contains a number of psychological conditions that are coded as three letters. I want to delete all people who don't have a particular psychological condition in one of their ten records. Here's and example of my data: ID_NUMBER PSYCH_COND 1 ANX 1 MDD 1 SKA 2 ANX 2 SKA 2 GAD 3 MDD 3 BPD 3 DDP 4 ANX 4 SKA 4 BPD So say I wanted to just keep the people (or ID numbers) who have ANX and delete the other people who didn't record ANX in any of their PSYCH_COND columns. Does anybody have any ideas as to how I would go about this? Thanks in advance!
... View more