Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | Tim Evans <Tim.Evans@wmciu.nhs.uk> |
To | "'statalist@hsphsun2.harvard.edu'" <statalist@hsphsun2.harvard.edu> |
Subject | st: rehape query? |
Date | Mon, 23 Jul 2012 12:11:13 +0100 |
Hi, I'm using Stata 11.2. I have a dataset in the following format: year dep_val m0004 m0509 m1014 1981 Affluent 536212 595619 719034 1981 Average 278534 299131 364013 1981 Deprived 638771 651976 800071 1982 Affluent 544452 564154 700325 1982 Average 283399 283462 353927 1982 Deprived 652394 618789 776801 1983 Affluent 551374 542624 680392 1983 Average 287977 272890 343038 1983 Deprived 666933 597369 751282 I wish to reconfigure the dataset so that it looks more like this: Year dep_val sex age_grp pop 1981 Affluent m 0004 536212 1981 Affluent m 0509 595619 1981 Affluent m 1014 719034 1981 Average m 0004 278534 1981 Average m 0509 299131 1981 Average m 1014 364013 I would group the data by year - i.e. 1981, each age_grp in each dep_val. Does anyone have a solution I could use, which is going to use some aspect of -reshape- I've got a little confused by it. Any help appreciated. _DISCLAIMER: This email and any attachments hereto contains proprietary information, some or all of which may be confidential or legally privileged. It is for the exclusive use of the intended recipient(s) only. If an addressing or transmission error has misdirected this e-mail and you are not the intended recipient(s), please notify the author by replying to this e-mail. If you are not the intended recipient you must not use, disclose, distribute, copy, print, or rely on this e-mail or any attachments, as this may be unlawful. * * 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/