Re: st: reshape question

["Sarah A. Mustillo" <smustillo@psych.mc.duke.edu>]

Sasha -

Thanks for the suggestion - I should have mentioned that I want to do this 
to about 450 variables with different names and am trying to avoid all that 
typing if possible!  Is there a way to tell Stata to move the letter from 
the front to the back on all the variables, without explicitly typing in 
all the variables or do I have a long night ahead of me?

Thanks again.

Sarah

--On Friday, February 07, 2003 5:21 PM -0500 "Oleksandr Talavera, BC" 
<talaveol@bc.edu> wrote:


> Hi,
> you can try to rename the variables:
>
> *---------
> local question 03 12
> local wave a b c d e
> foreach i of local question {
>         foreach  j of local wave {
>                     rename `j'`i'income income`i'`j'
>                     rename `j'`i'ed ed`i'`j'
>         }
> }
> *---------
>
>
> and then reshape...
>
> Best,
> Sasha
>
>
>
> Sarah A. Mustillo wrote:
>
> > Hi -
> >
> > I am trying to reshape a dataset from wide to long and can't figure
> > one small thing out.  My variables are all named with the j identifier
> > at the beginning of the variable, rather than at the end, e.g.,
> >
> > a03income
> > b03income
> > c03income
> > d03income
> > e03income
> >
> > a12ed
> > b12ed
> > c12ed
> > d12ed
> > e12ed
> >
> > etc.
> >
> > where a,b,c,d,e stands for wave. I want to:
> >
> > reshape long [many variables], i(id) j(wave) string
> >
> > but, of course, Stata seems to be looking to the end of my variables
> > for the wave identifier when mine are at the beginning.  I have been
> > trying to use my limited programming skills to move the letter from
> > the beginning to the end on all of the variables, but haven't been
> > able to do it.
> >
> > Any suggestions?
> >
> > Thanks!
> >
> > Sarah
> >
> >
> >
> >
> > Sarah A. Mustillo, Ph.D
> > Center for Developmental Epidemiology
> > Department of Psychiatry and Behavioral Sciences
> > Duke University School of Medicine
> > Box 3454
> > Durham NC 27710
> >
> > 919 687-4686 x234
> >
> > *
> > *   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/
>
> *
> *   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/


Sarah A. Mustillo, Ph.D
Center for Developmental Epidemiology
Department of Psychiatry and Behavioral Sciences
Duke University School of Medicine
Box 3454
Durham NC 27710

919 687-4686 x234

*
*   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/