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 at the end of May, and its replacement, statalist.org is already up and running.


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

Re: st: RE: comas in numbrers


From   "vmz@vol.net.mt" <vmz@vol.net.mt>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   Re: st: RE: comas in numbrers
Date   Mon, 03 May 2010 10:02:26 +0100

That.s really wonderfull Steve and Jose' .Your help is greatly
appreciated,
Victor
On 3/5/2010, "Steve Samuels" <sjsamuels@gmail.com> wrote:

>assume that your commas are not separating the integer from the
>non-integer part of the numbers, but instead are indicating
>thousands--see Jose's post today.
>
> I suggest that you use -filefilter- instead of -sed- , Since this is
>a Stata command, it will be platform independent, whereas the -sed-
>command on your system might have a different syntax than the one on
>mine (OS X 10.5.8, bash shell) . (The  "-e" might be an issue; you
>could omit it.)  Either one of these two statements should work.
>
>filefilter file1.txt file2.txt, from(",") to("")  //best
>filefilter file1.txt file2.txt, from(\044d) to("")
>
> Monitor what is in file2.txt  either  by opening it up in your text
>editor (best), or using -type-.
>
>  I'm not sure what you mean by "highlighting" the data, and I'm not
>sure that I consider the do file editor as a good text editor. (I
>wouldn't want to use it with a thousand-line file).  Still, while you
>are there (or in a good text editor), why not search for and replace
>the comma, save out, as Jose and Nick suggested.
>'
>Good luck,
>
>Steve
>
>On Sun, May 2, 2010 at 12:20 PM, vmz@vol.net.mt <vmz@vol.net.mt> wrote:
>> Thanks Steve ,however I seem to be doing something wrong with processing
>> the following data into a file calling it file1.txt. I am doing this by
>> highlighting the data,copy it and paste it into a do-file and then
>> saving it as file1.txt.       .....
>>
>>  31,666 15,127 46,793 31,259 15,409 46,668 30,215 17,182 7,397
>>  28,323 13,798 42,121 28,267 14,024 42,291 27,049 15,886 2,935
>>  6,615 2,307 8,922 6,668 2,602 9,270 6,130 3,380 9,510
>>  7,829 4,196 12,025 7,556 3,855 11,411 7,020 4,336 11,356
>>  5,583 2,809 8,392 6,098 2,856 8,954 6,177 3,145 9,322
>>  4,399 2,421 6,820 4,311 2,520 6,831 4,119 2,609 6,728
>>  3,897 2,065 5,962 3,634 2,191 5,825 3,603 2,416 6,019
>>  3,343 1,329 4,672 2,992 1,385 4,377 3,166 1,296 4,462
>>
>>  do "C:\DOCUME~1\Victor\LOCALS~1\Temp\STD04000000.tmp"
>>
>>  capture erase file2.txt
>>
>>  ! sed -e 's/,//g' file1.txt>file2.txt
>>
>> .
>>  infile v1 v2 v3 using file2.txt, clear
>> (0 observations read)
>>
>>  des
>>
>> Contains data
>>  obs:             0
>>  vars:             0
>>  size:             0 (100.0% of memory free)
>> Sorted by:
>>
>>  list
>>
>> .
>> end of do-file
>>
>>
>>
>> On 28/4/2010, "Steve Samuels" <sjsamuels@gmail.com> wrote:
>>
>>>Victor, you can skip all the problems of adding quotes or destringing
>>>by deleting the commas outside of Stata. Use the SED package, built
>>>into all the Unix, Linux, and OS X distributions and also available
>>>for Windows.  Write the data into a text file, say file1.txt.  Here is
>>>an example:
>>>
>>>**************************CODE BEGINS**************************
>>>/*
>>> File file1.txt contains the following two lines with three variables
>>>3,000,000 4,000,000    .
>>>     40,000   300,000 100
>>>*/
>>>capture erase file2.txt
>>>! sed  -e 's/,//g' file1.txt>file2.txt
>>>
>>>infile v1 v2 v3 using file2.txt, clear
>>>des
>>>list
>>>***************************CODE ENDS**************************
>>>
>>>Steve
>>>
>>>On Tue, Apr 27, 2010 at 5:16 PM, Martin Weiss <martin.weiss1@gmx.de> wrote:
>>>>
>>>> <>
>>>>
>>>> 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
>>>>>>+-----+
>>>>>>
>>>
>>>
>>>--
>>>Steven Samuels
>>>sjsamuels@gmail.com
>>>18 Cantine's Island
>>>Saugerties NY 12477
>>>USA
>>>Voice: 845-246-0774
>>>Fax:    206-202-4783
>>>
>>>
>>>
>>>--
>>>Steven Samuels
>>>sjsamuels@gmail.com
>>>18 Cantine's Island
>>>Saugerties NY 12477
>>>USA
>>>Voice: 845-246-0774
>>>Fax:    206-202-4783
>>>*
>>>*   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/
>>
>
>--
>Steven Samuels
>sjsamuels@gmail.com
>18 Cantine's Island
>Saugerties NY 12477
>USA
>Voice: 845-246-0774
>Fax:    206-202-4783
>
>*
>*   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