Hi, I have a dataset similar to below:
id name
1 Aaron, Sarah, Paul, Kim, Ted
2 Sarah, Aaron, Kim
3 Aaron, Kim, Paul
4 Aaron, Ted
I need to identify the top 2 occurring names which in this example should be Aaron and Kim. I tried the split name, parse(", ") command so I now have the names separately in four columns, some resulting cells not containing any observation.

Is there a way to count and tabulate frequency across several tabs (if possible show only top 2)? Otherwise, any other approach that could get me to the result I need would be greatly appreciated.

Also to note: I looked up the tabsplit command but it doesn't seem to work on Stata 13 so not sure if that would have been helpful. Not possible for me to update to higher versions of Stata as of now.

Thank you!!