[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: RE: RE: unique value count in several variables
By "unique" here I think you mean "distinct".
Try -groups- from SSC. Or -egen, group()-
and then tabulate.
> 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.
* For searches and help try: