<>
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: [email protected]
[mailto:[email protected]] Im Auftrag von
[email protected]
Gesendet: Dienstag, 3. März 2009 14:21
An: [email protected]
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: [email protected]
> [mailto:[email protected]] Im Auftrag von
> [email protected]
> Gesendet: Dienstag, 3. März 2009 12:29
> An: [email protected]
> 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: [email protected]
>> [mailto:[email protected]] Im Auftrag von
>> [email protected]
>> Gesendet: Dienstag, 3. März 2009 10:08
>> An: [email protected]
>> 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/
