Isabelle,
in addition to Martin's comments, be aware that Stata will not
recognise .. (dot dot) as being numeric. Missing values are coded .
(dot) in Stata. If you really have .. in your healthinit variable, you
will have to replace those with . or an empty cell before applying
-destring healthinit, replace-.
Eva
2009/3/3  <[email protected]>:
> 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
>
>
*
*   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/