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]
Re: st: Preserve Variable Labels After Reshape
From
Joerg Luedicke <[email protected]>
To
[email protected]
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 <[email protected]> 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" <[email protected]> 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 <[email protected]> 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" <[email protected]> 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 <[email protected]> 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/