Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | "Özlen D. Luznar" <ozlend1@umbc.edu> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | st: best way to add up values sorted by a unique id |
| Date | Thu, 24 Jun 2010 16:25:58 -0400 (EDT) |
Hi everyone, I have a dataset where I am trying to calculate total family income identified by a unique family id "unifam". Each person in the unifam has a totalannual income and I am trying to add totalannual income to calculate annual family income - at the unifam level. For example unifam==1 person=1 totalincome == 60 unifam ==1 person=2 titalincome == 40 unifam=1 totalfamilyincome == 100 unifam ==2 person=1 totalincome = 100 unifam==2 person=2 totalincome= 50 unifam =2 person=3 totalincome =50 unifam =2 totalfamilyincome ==200 Thanks! -- Özlen D. Luznar PhD Candidate - Public Policy Graduate Research Assistant University of Maryland Baltimore County (UMBC) 1000 Hilltop Circle Baltimore, MD 21250 443-846-5010 * * 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/