Re: AW: AW: st: AW: problem with the generate command

[Steven Samuels <sjhsamuels@earthlink.net>]

How about:


*************************************************
clear
insheet country healthinit health using d01.txt, names tab
des
list
gen h3= trim(regexr(healthinit,"\.\.","."))
destring h3, gen(h)
sum h health

**************************************************

-Steve

On Mar 3, 2009, at 8:54 AM, Martin Weiss wrote:

> <>
>
> Isabell`s data are weird, though. I have tried several approaches  
> to make
> the "healthinit" numeric, and have not managed in Stata. -trim()-  
> should
> kill the blanks surrounding the numbers in "healthinit" (so that - 
> destring-
> can work on these data) but does not. The only thing that got them  
> to behave
> well was to clean the data with a plug-in for a well-known spreadsheet
> application.
>
>
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von
> Isabelle.Roux@ehess.fr
> Gesendet: Dienstag, 3. März 2009 14:21
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: AW: st: AW: problem with the generate command
>
> Dear all,
>
> Thank you very much for this helpful advice.
> Stata refuses to replace .. by a blank. I type:
>
> *******
> replace healthinit="" if "healthinit"==..
>
> ******
>
> I have:"nothing found where name expected".
> If I try:*replace healthinit="" if healthinit==".."*, it does not work
> better. Is there a problem with my command?
>
>
>
> Then when I write:
> **
> encode healthinit, gen(H)
> ta H
> ta H, nolabel
> generate health=1.06*H
>
> **
> I have the same resultas for health
>
>
> > <>
> >
> > After your -encode- command, type
> >
> > *************
> > ta H
> > ta H, nolabel
> > *************
> >
> > and note the difference. -destring- is your command of choice, and  
> > pay
> > attention to Eva`s remark for the missings.
> >
> >
> > HTH
> > Martin
> >
> >
> > -----Ursprüngliche Nachricht-----
> > Von: owner-statalist@hsphsun2.harvard.edu
> > [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von
> > Isabelle.Roux@ehess.fr
> > Gesendet: Dienstag, 3. März 2009 12:29
> > An: statalist@hsphsun2.harvard.edu
> > Betreff: Re: st: AW: problem with the generate command
> >
> > Dear Martin,
> > Thank you very much for all your help since the beginning I use  
> > Stata.
> > Here are my data (just the beginning!):
> >
> > country	     healthinit	H	 health
> >  Afghanistan	13.00 	13.00 	 23.32
> >  Albania  	116.00 	116.00 	 16.96
> >  Algeria	     76.00 	76.00 	 169.6
> >  American Samoa	..  	..  	 1.06
> >  Andorra	      1922.17 	1922.17 	 54.06
> >  Angola	     24.00 	24.00 	72.08
> >  Antigua and Barbuda	492.00 	492.00 	138.86
> >  Argentina	283.00 	283.00 	89.04
> >  Armenia	      53.00 	53.00 	145.22
> >  Aruba	      ..  	..  	1.06
> >
> > Healthinit is the health expenditure per capita in current  
> > dollars. It is
> > a string variable. It comes from the wdi database. As I want them in
> > euros, and that the exchange rate is 1.06 (year is 2003), I wrote to
> > stata:
> >
> > encode healthinit, gen(H)
> > generate health=1.06*H
> >
> > H is a long variable.
> >
> > Danke schön für die Helfe!
> >
> > Isabelle
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > > <>
> > >
> > > A bug in -generate- would be weird indeed. Give an excerpt of  
> > > your data,
> > > and
> > > show us exactly what you typed and what Stata made of it...
> > >
> > > HTH
> > > Martin
> > >
> > >
> > > -----Ursprüngliche Nachricht-----
> > > Von: owner-statalist@hsphsun2.harvard.edu
> > > [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von
> > > Isabelle.Roux@ehess.fr
> > > Gesendet: Dienstag, 3. März 2009 10:08
> > > An: statalist@hsphsun2.harvard.edu
> > > Betreff: st: problem with the generate command
> > >
> > > Hello,
> > >
> > >
> > > I have a health expenditure variable in current dollars, called  
> > > H. It is
> > > a
> > > numeric variable ("long"). I called it "H". I want to convert it in
> > > euros,
> > > e.g to multiply by 1,6 so I write in my do-file:
> > > "gen health=1.6*H"
> > > I am very surprised because the results are wrong. It is very  
> > > strange.
> > > For
> > > instance:
> > > H=13.00   and  Health=23.32 (first observation)
> > > or: H=116.00 and Health=16.96 (2d one)
> > > or: H=76.00 and Health=169.6
> > >
> > > Thank you very much for help
> > > Best regards
> > >
> > > Isabelle
> > >
> > > *
> > > *   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/
> > >
> > >
> > > *
> > > *   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/
> >
> >
> > *
> > *   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/
> >
> >
> > *
> > *   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/
>
>
> *
> *   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/
>
>
> *
> *   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/


*
*   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/