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

["Lachenbruch, Peter" <Peter.Lachenbruch@oregonstate.edu>]

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/