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: comas in numbrers


From   "Martin Weiss" <martin.weiss1@gmx.de>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: RE: RE: RE: comas in numbrers
Date   Tue, 27 Apr 2010 23:16:35 +0200

<>

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/


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index