Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: Preserve Variable Labels After Reshape


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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index