Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

st: RE: unique value count in several variables


From   "Wanli Zhao" <zhaowl@temple.edu>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: unique value count in several variables
Date   Fri, 17 Jun 2005 22:52:40 -0400

Hello, Statalisters!

I have a simple question but got stuck on a simple solution. I have a panel
and let's say cross-section id is gvkey and time id is year. There are two
variables, say, primary sic and secondary sic. My aim to count the unique
value of sic in both variables by gvkey by year. I know the 'by' thing is
straightforward but is there a quick solution to count the unique
observation in both variables? I know the commands such as unique, distinct
and egenmore nvals. They work perfect for a single variable. Also, on the
webpage there is a explanation of the unique combination of two variables
and how to count that. I guess mine is different. Your help is appreciated.

Cheers,
Wanli Zhao
Using Stata 9 


*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index