Generate a list of unique firms

[Helen Chang]

Hi, I have a panel data and would like to generate a list of unique firms (e.g. gvkey), preferable exporting this list to excel or word. Is there any way to achieve this? I usually use distinct gvkey to know the number of unique firms.

Thanks!

[Rich Goldstein]

use the -duplicates- command; you may want to temporarily delete all other variables first and then

duplicates drop gvkey

see

help duplicates

[William Lisowski]

Perhaps the following approach will also accomplish what you seek.

egen onekey = tag(gvkey)
export excel gvkey using filename if onekey