Counting unique string variables

[Sabine Swennenhuis]

Hi,

I'm creating a variable for overconfident CEOs. The measure depends on if CEO share ownership is more than the industry median. So far it worked out. But now I want the count the unique number of CEO names (CEOname/string variable) based on another variable: differenceshares (the difference between the ceo ownership and the industry median). I want to know how many of those CEOs are considered overconfident. So how many unique values of CEOname there are if differenceshares is positive/negative.

thanks in advance,
Sabine

[Nick Cox]

This may help: http://www.stata-journal.com/sjpdf.h...iclenum=dm0042

Among other things, it explains that "unique" is not a good term here.

If that isn't enough, I imagine most people who might answer would much prefer a data example. One clear example is worth a volume of exegesis.

[Sabine Swennenhuis]

Thank you very much, it worked out