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]

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/

**Follow-Ups**:**RE: st: Sort rows and give variable name of the observation***From:*Haluk Vahaboglu <[email protected]>

**References**:**st: Sort rows and give variable name of the observation***From:*Haluk Vahaboglu <[email protected]>

**Re: st: Sort rows and give variable name of the observation***From:*Maarten Buis <[email protected]>

**RE: st: Sort rows and give variable name of the observation***From:*Haluk Vahaboglu <[email protected]>

- Prev by Date:
**RE: st: Sort rows and give variable name of the observation** - Next by Date:
**Re: st: 0 lag command for Pooled Mean Group (PMG) Estimator** - Previous by thread:
**RE: st: Sort rows and give variable name of the observation** - Next by thread:
**RE: st: Sort rows and give variable name of the observation** - Index(es):