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: reshaping + info from label
From
Abhimanyu Arora <[email protected]>
To
[email protected]
Subject
Re: st: reshaping + info from label
Date
Tue, 25 Oct 2011 02:46:32 +0200
Thanks Nick, let me pls elaborate the problem.
The reason why -ds- or your -findname- come into the picture is
because I would like to take some strings out of the variable label
and place them into the data.
So let us consider only one variable variable1ab. "A B" is the
variable label for the variable variable1ab and I would like to create
2 new variables taking up the values (two strings from the label) A
and B and the third variable takes up the original value of the
variable. The reason for all this is that I would eventually like to
take some correlations -by- A and B (this information is available in
the variable label).
Cheers
Abhimanyu
On Tue, Oct 25, 2011 at 2:10 AM, Nick Cox <[email protected]> wrote:
> You don't show what you tried with -reshape-. If these were string
> variables, then you can go
>
> input date str1 variable1ab str1 variable2cd
> . 1 q w
> . 2 e r
> end
> reshape long variable, i(date) string
> l
>
> +-----------------------+
> | date _j variable |
> |-----------------------|
> 1. | 1 1ab q |
> 2. | 1 2cd w |
> 3. | 2 1ab e |
> 4. | 2 2cd r |
> +-----------------------+
>
> I don't follow what you are trying to explain about labels. Value
> labels? Variable labels? Nor do I follow what the connection with -ds-
> or -findname- (SJ) is here.
>
> Nick
>
> On Tue, Oct 25, 2011 at 12:11 AM, Abhimanyu Arora
> <[email protected]> wrote:
>
>> I am trying to reshape data that has the following form---
>>
>> date variable1ab variable2cd
>> 1 q w
>> 2 e r
>>
>>
>>
>> Assume the variable variable1ab is labelled A B, while variable2cd is
>> labelled C D (actually strings, though)
>>
>>
>> Finally I would like the data to be of the following form
>>
>> date var1 var2 value
>> 1 A B q
>> 2 A B e
>> 1 C D w
>> 2 C D r
>>
>>
>> I feel the solution might lie in the commands -ds- or Nick Cox's
>> -findname- together with -reshape- but I am just unable to see how.
>
> *
> * 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/