The following will work :
input str9 a
100-2555
500-2341
564-5213
end
gen aa = substr(a,1,3)+substr(a,5,4)
destring aa,gen(s)
list
Note that aa is string variable and s is numeric variable
----- Original Message -----
From: Austin Nichols <[email protected]>
To: <[email protected]>
Sent: Thursday, April 20, 2006 6:55 PM
Subject: Re: st: Substring command
> read -help strfun-
> and try
> . replace code = subinstr(code,"-","",.)
>
> On 4/20/06, Mosca, Ilaria <[email protected]> wrote:
> > Dear statalisters,
> >
> > I have a string variable that looks like the following:
> > 100-2555
> > 500-2341
> > 564-5213
> > I would like to generate another variable that takes away the dash. In
> > other words, the new variable would be the following:
> > 1002555
> > 5002341
> > 5645213
> >
> > I tried with the command --replace code = subinstr(code,"-","")
> > But I obtain an "invalid syntax r(198)" message.
> >
> > What should I do?
> >
>
> *
> * For searches and help try:
> * http://www.stata.com/support/faqs/res/findit.html
> * http://www.stata.com/support/statalist/faq
> * http://www.ats.ucla.edu/stat/stata/
>
*
* For searches and help try:
* http://www.stata.com/support/faqs/res/findit.html
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/
