Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Collapse and aggregation

From   Santosh Kumar <>
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.




*   For searches and help try:

© Copyright 1996–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index