Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
| From | Nick Cox <njcoxstata@gmail.com> |
| To | statalist@hsphsun2.harvard.edu |
| Subject | Re: st: reshape query |
| Date | Tue, 4 Dec 2012 13:07:47 +0000 |
You want male and female values to be in two observations of the same variable, not two variables for each observation. At the heart of -reshape- is the idea that that not variable names, but stub names (typically prefixes) indicate what you want. You supplied -m- and -f- as stubnames, so -reshape- takes you at your word. This isn't a problem with -reshape-, as it is doing what you asked. You just need to rename your -m- and -f- to have some common -prefix-, say -genderm- and -genderf- or -gender0- and -gender1-, and then it is a -reshape long-. On Tue, Dec 4, 2012 at 12:30 PM, Tim Evans <Tim.Evans@wmciu.nhs.uk> wrote: > I'm using Stata 11.2, and am having a little trouble with -reshape-. > > I have a dataset with data as such: > > year age Males age mmx mqx mlx mdx mex Females fmx fqx flx fdx fex > 1982 0.00 Males 0.00 0.01 0.01 100000.00 1281.70 70.81 Females 0.01 0.01 100000.00 994. 76.80 > > I want to set the data up so that I have: > > Year Sex age mx qx lx dx ex > 1982 Males 0 0.01 0.01 100000.00 1281.70 70.81 > 1982 Females0 0.01 0.01 100000.00 994.0 76.80 > > I've been trawling a few bits of code that I have used in the past and not finding a solution: > > > g id=_n > reshape long m f, i(id age year) string > > > But this gives this output: > > id age year _j m f > 1 0 1982 dx 1281.7 994.7 > 1 0 1982 ex 70.81 76.8 > 1 0 1982 lx 100000 100000 > 1 0 1982 mx .0129 .009997 > 1 0 1982 qx .012817 .009947 > > I'm sure I probably need another -reshape- around _j * * For searches and help try: * http://www.stata.com/help.cgi?search * http://www.stata.com/support/faqs/resources/statalist-faq/ * http://www.ats.ucla.edu/stat/stata/