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 <njcoxstata@gmail.com> |

To |
"statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu> |

Subject |
Re: st: seperate text in a variable repeatedly across many variables |

Date |
Sun, 27 Feb 2011 18:22:39 +0000 |

That is, foreach v of var household_history_* { split `v', p(";") gen(`v'_) } That way household_history_1 gets mapped to household_history_1_1 etc., household_history_10 goes to household_history_10_1, etc., household_history_100 goes to household_history_100_1, etc. Nick On Sat, Feb 26, 2011 at 8:57 PM, Nick cox <njcoxstata@gmail.com> wrote: > Possibly add a -gen()- option specifying > > left quote > v > right quote > underscore > > as stub. (This device is punctuation-challenged.) > > Nick > > > > On 26 Feb 2011, at 20:10, "Ben Ammar" <Ben-Ammar@gmx.de> wrote: > >> Hi Nick & everybody, >> >> first of all thanks for your answer. I tried what you suggested. >> Unfortunately that didn't work as I always got back "invalid syntax". Now I >> know why: Ususally Stata would put a stub of 1, 2 etc. at the end of each >> newly created variable. But since I got 100 variables (household_history1 up >> to household_history100) that I want to be separated, Stata isn't very happy >> that there are more than 9 variables. A varlist for household_history10 - >> household_history100 can be splitted and is no problem. I also tried the >> "generate()" option but that didn't work either. >> Any ideas about how to split all variables including the first 10? >> >> Thanks everybody! >> -------- Original-Nachricht -------- >>> >>> Datum: Fri, 25 Feb 2011 08:43:13 +0000 >>> Von: Nick Cox <njcoxstata@gmail.com> >>> An: statalist@hsphsun2.harvard.edu >>> Betreff: Re: st: seperate text in a variable repeatedly across many >>> variables >> >>> The syntax of your -foreach- call is wrong. Look again at the help to >>> see the forms alllowed and try >>> >>> foreach v of var household_history_* { >>> split `v', p(";") >>> } >>> >>> Nick >>> >>> On Fri, Feb 25, 2011 at 8:36 AM, Ben Ammar <Ben-Ammar@gmx.de> wrote: >>> >>>> I'm new to Stata so please excuse if this question isn't the greatest: >>>> >>>> I want to seperate a text (string) across several variables. In each >>> >>> variable (household_history_1 up to household_history_100) there's a >>> semicolon. So I thought of: >>>> >>>> .foreach household_history_* { >>>> .split household_history_*, p(";") >>>> .} >>>> >>>> unfortunately Stata says "too many variables specified". Maybe the >>> >>> approach is entirely wrong. I'd be very thankful for any comments! > * * 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/

**References**:**st: seperate text in a variable repeatedly across many variables***From:*"Ben Ammar" <Ben-Ammar@gmx.de>

**Re: st: seperate text in a variable repeatedly across many variables***From:*Nick Cox <njcoxstata@gmail.com>

**Re: st: seperate text in a variable repeatedly across many variables***From:*"Ben Ammar" <Ben-Ammar@gmx.de>

**Re: st: seperate text in a variable repeatedly across many variables***From:*Nick cox <njcoxstata@gmail.com>

- Prev by Date:
**Re: st: Mlogit: Log pseudolikelihood bug?** - Next by Date:
**Re: st: Log Transformation of Variable** - Previous by thread:
**Re: st: seperate text in a variable repeatedly across many variables** - Next by thread:
**st: Mata : getting covariance matrix with moptimize()** - Index(es):