Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
st: Collapse and aggregation
From
Santosh Kumar <[email protected]>
To
[email protected]
Subject
st: Collapse and aggregation
Date
Mon, 20 Sep 2010 08:37:57 -0400
Dear all.
I have individual level data, nested in year, county, and state. for eg: in
states, there are many counties and in counties, there are many years and or
each years there are many individuals.
I want to aggregate this data to county and year level, but also want to
keep the statecode or statename in order to identify which county belongs to
which state.
How can I use "collapse" command to aggregate in such manner or please
advise any other different way to get to this. Keeping the state name or
code is crucial for analysis.
Do appreciate y help.
SK
--
Santosh
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/