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: Data Management Loop


From   Scott Merryman <scott.merryman@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: Data Management Loop
Date   Fri, 1 Apr 2011 15:24:10 -0500

Here is one way to restructure your data:

clear
input id type   x
1 1       1
2 2       2
3 1       3
4 2       4
5 1       5
6 2       6
end

preserve
reshape wide x, j(id) i(ty)
tempfile tmp
sort type
replace type = 2*(type==1) + (type==2)
save `tmp'
restore

merge m:1 type using `tmp'
drop _m
sort id type
l

Scott


On Fri, Apr 1, 2011 at 1:45 PM, Toby <spiegeldesaster@googlemail.com> wrote:
> Thanks for your reply!
>
> Doing this, I think (!) I can compare the the x value of type 1 with
> every other x value of type 2. This will give me a hint about how
> often a certain value x of type 1 is higher/lower/ or equal compared
> to all other values in the sample. Vice versa for type 2. Due to my
> limited programming capabilities I thought this would be an easy way.
> Do you think there is a better way? (Certaintly there is. =) )
>
> Toby.
>
>
> 2011/4/1 Nick Cox <njcoxstata@gmail.com>:
>> I think the main question is not how to get this, but how and why do
>> you imagine it will help you?
>> For each type, the information is already accessible. Why repeat it?
>>
>> Nick
>>
>> On Fri, Apr 1, 2011 at 7:14 PM, Toby <spiegeldesaster@googlemail.com> wrote:
>>> Hello Statalist,
>>>
>>> i have a problem with the following data structure:
>>>
>>> id type   x
>>> 1 1       1
>>> 2 2       2
>>> 3 1       3
>>> 4 2       4
>>> 5 1       5
>>> 6 2       6
>>>
>>> Now I want to generate additional variables that include the x value
>>> for the opposite type, so that the data looks like this:
>>>
>>> id type   x   x_2   x_4    x_6   x_1    x_3   x_5
>>> 1 1       1    2      4        6
>>> 2 2       2    .       .        .         1     3         5
>>> 3 1       3    2     4         6
>>> 4 2       4    .       .        .         1     3         5
>>> 5 1       5    2     4         6
>>> 6 2       6    .       .        .         1     3         5
>>>
>>> Until know I only have created a loop that generates this additional
>>> variables, but I did not figured out how to disriminate between the
>>> two type. Can anyone hive me a hint?
>>>
>>> Kind regards,
>>> Toby.
>>> *
>>> *   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/
>>
>
> *
> *   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/


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