Statalist


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

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


From   Steven Samuels <[email protected]>
To   [email protected]
Subject   Re: AW: AW: AW: st: AW: problem with the generate command
Date   Tue, 3 Mar 2009 11:10:19 -0500

--

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/



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