[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
st: Re: Identifying repeated observations in different panels
If you want a count of the number of provinces in each code_institution:
bysort code_institution province: gen perprovince=(_n==1)
by code_institution : egen numprovince=sum(perprovince)
You could then:
list province code_instituition if numprovince>1 & perprovince==1
----- Original Message -----
From: "Mosca, Ilaria" <IMosca@ctg-zaio.nl>
Sent: Wednesday, January 18, 2006 6:54 AM
Subject: st: Identifying repeated observations in different panels
I have a database with the following information:
What I would like to know is if there exists some institutions that are
active in more than one province. In the example above such institution
would be the code_institution 10521, which is present both in province 1
and province 2.
Probably my question will sound loopy but is there any command that
allows me to do this? Note that I've already dropped all the duplicates
in the data set.
Assuming that such command exists, what can I type next to summarize the
results in a nice table? Namely seeing that the code_institution 10521
is active in province 1 and 2, and so forth.
Thanks in advance for your help,
* For searches and help try: