Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

From |
Joerg Luedicke <joerg.luedicke@gmail.com> |

To |
statalist@hsphsun2.harvard.edu |

Subject |
Re: st: Preserve Variable Labels After Reshape |

Date |
Wed, 19 Dec 2012 21:24:41 -0500 |

Say we have 2 observations and 2 variables in wide format which we would like to reshape long. The data in wide format would look like: clear set obs 2 gen id=_n forval i=1/2 { gen x`i'=`i' label var x`i' "label `i'" } . li +--------------+ | id x1 x2 | |--------------| 1. | 1 1 2 | 2. | 2 1 2 | +--------------+ Both variables x1 and x2 are labeled. Now we reshape: reshape long x, i(id) j(year) and get: . li +---------------+ | id year x | |---------------| 1. | 1 1 1 | 2. | 1 2 2 | 3. | 2 1 1 | 4. | 2 2 2 | +---------------+ Where exactly would you want the original labels to go? What was stored in two variables before is now stored in one variable. Joerg On Wed, Dec 19, 2012 at 9:13 PM, David Torres <writeon4truth2@msn.com> wrote: > The 150 variables I have, however, are the same in each of five files, each representing a different year. The labels are the same. I am simple trying to keep those labels after a reshape. I fail to see how in my case this doesn't make sense. > > Cheers > > Sent from my iPhone > > On Dec 19, 2012, at 8:07 PM, "Joerg Luedicke" <joerg.luedicke@gmail.com> wrote: > >> I agree with Nick that this makes no sense. Say you reshape your 150 >> variables such that you have only one variable in long format, then >> you have only one variable for which you can use one label. >> >> Joerg >> >> On Wed, Dec 19, 2012 at 8:58 PM, David Torres <writeon4truth2@msn.com> wrote: >>> Okay, is there a way to save the labels and reinsert them after reshape? I'm not too keen on having to retype labels for 150 variables. >>> >>> Thanks >>> >>> Sent from my iPhone >>> >>> On Dec 19, 2012, at 7:24 PM, "Nick Cox" <njcoxstata@gmail.com> wrote: >>> >>>> How could they be preserved? A -reshape- is not a one-to-one mapping. >>>> >>>> Nick >>>> >>>> On Thu, Dec 20, 2012 at 1:16 AM, David Torres <writeon4truth2@msn.com> wrote: >>>>> I'm reshaping some data from wide to long and would like to preserve my variable labels. Does anyone know an easy way to do this? >>>>> >>>>> I've already tried the user-written commands -longshape-, -reshape7-, and -reshape8-. My variable labels were not preserved. >>>> * >>>> * 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/ >>> >>> * >>> * 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/ >> * >> * 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/ > > * > * 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/ * * 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/

**Follow-Ups**:**RE: st: Preserve Variable Labels After Reshape***From:*David Torres <writeon4truth2@msn.com>

**References**:**st: Preserve Variable Labels After Reshape***From:*David Torres <writeon4truth2@msn.com>

**Re: st: Preserve Variable Labels After Reshape***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: Preserve Variable Labels After Reshape***From:*David Torres <writeon4truth2@msn.com>

**Re: st: Preserve Variable Labels After Reshape***From:*Joerg Luedicke <joerg.luedicke@gmail.com>

**Re: st: Preserve Variable Labels After Reshape***From:*David Torres <writeon4truth2@msn.com>

- Prev by Date:
**Re: st: Preserve Variable Labels After Reshape** - Next by Date:
**RE: st: Preserve Variable Labels After Reshape** - Previous by thread:
**Re: st: Preserve Variable Labels After Reshape** - Next by thread:
**RE: st: Preserve Variable Labels After Reshape** - Index(es):