st: data manipulation

["Branislav Seslija" <bseslija@hotmail.com>]

I need to flip the data so that each unique combination of prog_id and object_i is a unique variable with the counties in each state becoming row entries. Unfortunatly these data are for a single year so that i can not fool reshape into doing what i wanted to do. Any tips would be very beneficial.

Thank you,

Branislav

prog_id object_i f_state f_county amounttotal amount year
10.001 GG 11 001 65000 65000 1983
10.001 GG 12 001 27382 27382 1983
10.001 GG 25 025 2377300 2377300 1983
10.001 GG 32 031 179800 179800 1983
10.001 GG 48 201 2608800 2608800 1983
10.025 GG 01 081 171250 171250 1983
10.025 GG 01 101 -26371 -26371 1983
10.025 GG 04 013 49800 24900 1983
10.025 GG 04 019 15000 15000 1983
10.025 GG 05 119 27000 27000 1983
10.025 GG 06 025 100000 100000 1983

Branislav Seslija, MA

Ph.D. Candidate in Political Science

Political Data Programming

Political Science (M/C 276)
1170A BSB

University of Illinois at Chicago

www.rcnchicago.com/~bseslija

---

STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/