RE: st: reshape query

[Tim Evans <Tim.Evans@wmciu.nhs.uk>]

Nick,

I'm still having a little trouble getting my head around this.

Are you saying of the  
Age
Males
mmx
mqx  
mlx     
mdx
mex
Females
fmx
fqx
flx
fdx
fex

I need to rename Males and Females to say genderm/genderf

Or are you saying that for each of these

mmx
mqx  
mlx     
mdx
mex

I need to rename them 
gendermmx
gendermqx  
gendermlx     
gendermdx
gendermex

Followed by 

-reshape long gender, i(id age year) string?

This returns (when only renaming the 'Males/Females' variables:

id	age	year	_j	gender	mmx		mqx		mlx		mdx	mex	fmx	fqx	flx	fdx	fex
1	0	1982	f	Females	.01		.01		100000	1281.7	70.81	.01	.01	100000	994.7	76.8
1	0	1982	m	Males		.01		.01		100000	1281.7	70.81	.01	.01	100000	994.7	76.8
2	1	1982	f	Females	.00087	.000869	98718.3	85.8	70.73	.000724	.000724	99005.3	71.6	76.57
2	1	1982	m	Males		.00087	.000869	98718.3	85.8	70.73	.000724	.000724	99005.3	71.6	76.57

Best wishes

Tim

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Nick Cox
Sent: 04 December 2012 13:08
To: statalist@hsphsun2.harvard.edu
Subject: Re: st: reshape query

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/

_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/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/