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]

st: RE: comas in numbrers


From   "vmz@vol.net.mt" <vmz@vol.net.mt>
To   "statalist@hsphsun2.harvard.edu" <statalist@hsphsun2.harvard.edu>
Subject   st: RE: comas in numbrers
Date   Sun, 02 May 2010 17:20:36 +0100

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/


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