[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

From |
Man Jia <jia.m@neu.edu> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: -reshape long- |

Date |
Sun, 10 Aug 2008 14:33:43 -0400 (EDT) |

Hi David, Thanks for your help! You are right--- It should be -drop if age~=19 & age~=20 age83 rather than age93. Thanks! Mandy David Kantor wrote: >At 01:20 AM 8/10/2008, Mandy Jia wrote: >>Hi all, >> >>I'm not familiar of the command -reshape-. So I was wondering if anyone >>could help me with an example of how to use -reshape- command. >> >>The data set I'm working on looks like this(w means wage) >>------------------------------------------------------------------------ >>- >>id age80 age81 age82 age93 age84 w80 w81 w82 w83 w84 >> >>1 18 19 20 21 22 10 11 13 14 14.2 >>2 19 20 21 22 23 15 16 16 14 15 >>3 17 18 19 20 21 9 9 10 11 >>11.4 >>--------------------------------------------------------------------- >>When I reshape the data set, I want to limit the age to the range >>[19,20]. >>In order to use fixed effects and random effects models to analyze, I >>want to reshape the data into: >>--------------------------------------------------------------------- >>id age w year >>1 19 11 81 >>1 20 13 82 >>2 19 15 80 >>2 20 16 81 >>3 19 10 82 >>3 20 11 83 >>--------------------------------------------------------------------- >>What I tried is as follows: >> >>.reshape long age w ,i(id) j(year) >>.drop if age~=19 | age~20 >>.sort id age >> >>My question is, is there any better way to do this? I'm not sure if >>what I did is OK, although I havn't found any weired thing in the >>result now. > >Your command looks correct. The age filter is a separate matter (and >I think you really meant -drop if age~=19 & age~=20). >You may want to inspect the data after the reshape -- before the age >filter -- to convince yourself that it did what you wanted. > >Also, I assume that in your data example you meant age83, rather than age93. > >I can't comment on how this fits in fixed effects and random effects >models. But in any case, it is good to be acquainted with -reshape-, >and in most cases, a long shape is the most useful. > >HTH. >--David > >* >* 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/ > * * 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/

**Follow-Ups**:**RE: st: -reshape long-***From:*"Nick Cox" <n.j.cox@durham.ac.uk>

- Prev by Date:
**Re: st: -reshape long-** - Next by Date:
**st: re: confidence interval for median** - Previous by thread:
**Re: st: -reshape long-** - Next by thread:
**RE: st: -reshape long-** - Index(es):

© Copyright 1996–2016 StataCorp LP | Terms of use | Privacy | Contact us | What's new | Site index |