<>
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: [email protected]
[mailto:[email protected]] Im Auftrag von Steven Samuels
Gesendet: Dienstag, 3. März 2009 17:10
An: [email protected]
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: [email protected]
> [mailto:[email protected]] Im Auftrag von Steven
> Samuels
> Gesendet: Dienstag, 3. März 2009 16:12
> An: [email protected]
> 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: [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/
>
>
> *
> * 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/
