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: Sort rows and give variable name of the observation
From
Nick Cox <[email protected]>
To
"[email protected]" <[email protected]>
Subject
Re: st: Sort rows and give variable name of the observation
Date
Thu, 21 Nov 2013 09:47:05 +0000
People interested in this kind of question might find
SJ-9-1 pr0046 . . . . . . . . . . . . . . . . . . . Speaking Stata: Rowwise
(help rowsort, rowranks if installed) . . . . . . . . . . . N. J. Cox
Q1/09 SJ 9(1):137--157
shows how to exploit functions, egen functions, and Mata
for working rowwise; rowsort and rowranks are introduced
a useful overview. Accessible at
http://www.stata-journal.com/sjpdf.html?articlenum=pr0046
Nick
[email protected]
On 21 November 2013 08:58, Haluk Vahaboglu <[email protected]> wrote:
> Antonis & Maarten,
> Many thanks for prompt responses. Both solutions are working.
> However, solving this problem with a loop is more versatile (for further problems) and enjoyable for me.
From: [email protected]
>> On Thu, Nov 21, 2013 at 7:19 AM, Haluk Vahaboglu wrote:
>>> I have a set of variables
>>> coded binary as 1/0 and an ID variable:
>>> ID x y z
>>> 1 1 0 0
>>> 2 0 1 0
>>> 3 0 0 1
>>> I want to search row-wise
>>> and find out the first occurrence of -1- to generate a new string
>>> variable displaying variable name of that obs.
>>
>> Here is one solution:
>>
>> *------------------ begin example ------------------
>> // create the example data
>> input ///
>> ID x y z
>> 1 1 0 0
>> 2 0 1 0
>> 3 0 0 1
>> end
>>
>> // an empty string "" is considered a missing value in Stata
>> // so the first occurance of a 1 happens when one of the
>> // variables is 1 and W is still missing
>> gen str1 W = ""
>> foreach var of varlist x y z {
>> replace W = "`var'" if `var' == 1 & missing(W)
>> }
>>
>> // admire the result
>> list
>> *------------------- end example -------------------
>> * (For more on examples I sent to the Statalist see:
>> * http://www.maartenbuis.nl/example_faq )
>>
>> Notice, that I gave the variable W the string storage type str1, which
>> means a string with 1 character. This works in this example since all
>> the variable names are only 1 character long. If in your real data the
>> longest variable name contains say 10 characters, you would replace
>> str1 with str10
>>
*
* 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/