This might be a basic question but I've been trying to create a variable to count the frequency of specific string values across a number of variables (e.g. Freq_ variables below), I've been looking in help but can't work out what I need to do. If it's a better idea I can recode to a numeric variable but I thought there would be a reasonably straightforward way of doing this.

Any advice gratefully received.



Item1 Item2 Item3 Freq_Red Freq_Blue Freq_Green
Case1 Green Green Green
Case2 Red Blue Green
Case3 Blue Red Red
Case4 Green Blue Green
Case5 Blue Red Green
Case6 Red Red Red
Case7 Green Red Red
Case8 Blue Green Blue
Case9 Red Blue Green