Forum Discussion
How to select cases
Hello, I have a following problem: In data participants are coded like this: P0001, P0002 etc. I have two different datas and in the bigger data there are participants P0001, P0002, P0003, P0...
Riny_van_Eekelen Thank you for your answer! I could use the VLOOKUP command, but the bigger data has several (tens) columns that I need. Do you know any way to for example delete all the cases that are not included in the smaller data?
RikuTauschi Perhaps like in the attached file?
Riny_van_Eekelen Yes, but the columns are different in each data. I edited your document and it's in attachments now. So I need the small data participants from the big data with big data's information.
The amount of rows in my real data is 800 and the amount of columns is about 40.
Like so? (please see the attached file)
Riny_van_Eekelen Exactly! 🙂