Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From   "Martin Weiss" <[email protected]>
To   <[email protected]>
Subject   AW: AW: st: AW: problem with the generate command
Date   Tue, 3 Mar 2009 14:54:56 +0100

<> 

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/



© Copyright 1996–2024 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index