Hi,

I want to find the amount of occurrences of a string variable across multiple variables by different groups. There's a large number of variables with various names so they might have to be renamed but I don't know how to do that either, note that this fact also makes it difficult for me to use the reshape command even though that might be a solution as well.

Here's an example:
ID V1 V2 V3 count_relevant_string
1 relevant_string relevant_string Gibberish word 2
2 Gibberish word Gibberish word relevant_string 1
3 Gibberish word Gibberish word Gibberish word 0
Where I want to create the variable count_relevant_string.

Thanks in advance
Jonatan