Statalist


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

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


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   AW: AW: AW: AW: st: AW: problem with the generate command
Date   Tue, 3 Mar 2009 17:51:11 +0100

<> 



Ok, I also cleaned the data prior to firing up Stata to make the thing work.
This is a very active thread (16 exchanges!) so let`s hope Isabell is still
with us and gives us an update whether we resolved her problem :-)



HTH
Martin


-----Ursprüngliche Nachricht-----
Von: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Steven Samuels
Gesendet: Dienstag, 3. März 2009 17:10
An: statalist@hsphsun2.harvard.edu
Betreff: Re: AW: AW: AW: st: AW: problem with the generate command

--

Martin, I did have a problem with the data. I copied the data from  
email. I had to zap the gremlins with a text editor before the -gen-  
statement would work. Note that "names" in my original -insheet-  
command should have been omitted.

The data were tab delimited with no quotes.

Here is the revised version.
*************************************************
type d01.txt
insheet country healthinit health using d01.txt, tab
gen h3= trim(regexr(healthinit,"\.\.","."))
destring h3, gen(h)
**************************************************

Output
************************************************
. type d01.txt
Afghanistan     13.00   23.32
American Samoa  ..      1.06
Andorra 1922.17 54.06

. insheet country healthinit health using d01.txt, tab
(3 vars, 3 obs)

. gen h3= trim(regexr(healthinit,"\.\.","."))

. destring h3, gen(h)
h3 has all characters numeric; h generated as double
(1 missing value generated)

. **************************************************
.


On Mar 3, 2009, at 10:18 AM, Martin Weiss wrote:

>
> <>
>
> Good call, but still gives me " h3 contains nonnumeric characters; no
> generate" for the -destring- line. Maybe Isabell`s data are not easily
> transferred between bodies of email messages and applications, so any
> difference in success between us may be entirely due to differences  
> in the
> initial dataset. As attachments are prohibited on the list, it is  
> hard to
> see how to overcome this problem...
>
>
> HTH
> Martin
>
>
> -----Ursprüngliche Nachricht-----
> Von: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] Im Auftrag von Steven  
> Samuels
> Gesendet: Dienstag, 3. März 2009 16:12
> An: statalist@hsphsun2.harvard.edu
> Betreff: Re: AW: AW: st: AW: problem with the generate command
>
>
>
> 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/
>
>
> *
> *   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–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index