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

[Nick Cox <njcoxstata@gmail.com>]

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/