Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down on April 23, and its replacement, statalist.org is already up and running.


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

st: RE: RE: RE: RE: RE: comas in numbrers


From   "Lachenbruch, Peter" <Peter.Lachenbruch@oregonstate.edu>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: RE: RE: RE: comas in numbrers
Date   Wed, 28 Apr 2010 07:09:22 -0700

I was reading the problem of entering numbers with the comma  used as a decimal point.  Can't Stata change the symbol for dp to ','?  If that's the case, can't the default be set to the comma and just read the numbers as general format?

________________________________________
From: owner-statalist@hsphsun2.harvard.edu [owner-statalist@hsphsun2.harvard.edu] On Behalf Of Martin Weiss [martin.weiss1@gmx.de]
Sent: Tuesday, April 27, 2010 2:16 PM
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: RE: RE: RE: comas in numbrers

<>

To answer this conclusively, we need to know where the data reside, i.e.
what kind of a file.

I just created a file "Book1.txt" from spreadsheet software, containing
numbers with commata in them, and used -insheet using Book1.txt, tab clear-
to get them into Stata. "tab" is just a red herring here so Stata does not
treat the commata as delimiters. Afterwards, I -destring-ed as described
before and ended up with a numeric variable in Stata. This approach could be
viable for you as well.


HTH
Martin

-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of vmz@vol.net.mt
Sent: Dienstag, 27. April 2010 19:54
To: statalist@hsphsun2.harvard.edu
Subject: st: RE: RE: RE: comas in numbrers

I mean thousands of observations,represented by numbers with a coma in
them.It is a problem because it would take too much time to quote
unquote each one of them.
Unfortunately,in Eurostat we come across commas in numbers.



On 27/4/2010, "Martin Weiss" <martin.weiss1@gmx.de> wrote:

>
><>
>
>What do you mean? There is no substantive difference to the situation with
5
>obs, is there? Apart from the fact that you do not want to -input- them
all,
>but that problem is unrelated to the issue of commata...
>
>
>HTH
>Martin
>
>
>-----Original Message-----
>From: owner-statalist@hsphsun2.harvard.edu
>[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of vmz@vol.net.mt
>Sent: Dienstag, 27. April 2010 19:16
>To: statalist@hsphsun2.harvard.edu
>Subject: st: RE: RE: comas in numbrers
>
>What do I do when there are thousands of observations?
>
>
>
>010, "Martin Weiss" <martin.weiss1@gmx.de> wrote:
>
>>
>><>
>>
>>*************
>>
>> drop _all
>>
>>input str10 a
>>"2,345"
>>"213"
>>"34,456"
>>"458"
>>end
>>
>>destring a, generate(numerica) ignore(,)
>>l
>>*************
>>
>>
>>HTH
>>Martin
>>
>>-----Original Message-----
>>From: owner-statalist@hsphsun2.harvard.edu
>>[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of vmz@vol.net.mt
>>Sent: Dienstag, 27. April 2010 17:39
>>To: statalist@hsphsun2.harvard.edu
>>Subject: st: RE: comas in numbrers
>>
>>Dear Statalist,
>>
>>how do you handle numbers with a coma to indicate thousands?
>>I thank you before hand
>>Victor M. Zammit
>>
>> drop _all
>>
>> input a
>>
>>a
>>1. 2,345
>>2. 213
>>3. 34,456
>>4. 458
>>5. end
>>
>>..
>>end of do-file
>>
>> l
>>
>>+-----+
>>a
>>-----
>>1.    2
>>2.  213
>>3.   34
>>4.  458
>>+-----+
>>
>>*
>>*   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   |   Site index