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

[Nick cox <njcoxstata@gmail.com>]

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/