Bookmark and Share

Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.


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

Re: st: Data format query


From   Susan Olivia <[email protected]>
To   [email protected]
Subject   Re: st: Data format query
Date   Tue, 24 May 2011 15:50:22 +1000

Thanks Ana. the 'subinstr' command that you suggested do what I after.

Cheers,

Susan

On 24 May 2011 15:23, Vitorino, Maria Ana <[email protected]> wrote:
> Hi Susan,
>
> I tried the following and it worked...
>
> replace Revenue= subinstr(Revenue,"_","",.)
> replace Revenue= subinstr(Revenue,".","",.)
>
> Hope this helps,
>
> Ana
>
>
> On May 24, 2011, at 12:08 AM, Susan Olivia wrote:
>
>> Dear StataListers,
>>
>> I have the data in following format [plese see below]. Ideally I would
>> like the data to display without the "__" and ".". I tried using the
>> 'substr' command didn't really doing what I after. This variable is
>> currently in string format. Unfortunately, encode, recode or replace
>> didn't work either.
>>
>> Any tips how to handle this much appreciated.
>>
>> Thanks,
>>
>> Susan
>>
>>
>>
>> . tab b44
>>
>> b44.Revenue |
>>    /Amount   |      Freq.     Percent        Cum.
>> ------------------ +-----------------------------------
>> 160.000.000 |          1        0.03        1.84
>> _10.000.000 |          3        0.08        1.92
>> _10.100.000 |          1        0.03        1.94
>> _10.200.000 |          2        0.05        2.00
>> _10.210.000 |          1        0.03        2.02
>> _10.800.000 |          4        0.10        2.13
>> _11.000.000 |          4        0.10        2.23
>> _11.087.200 |          1        0.03        2.26
>> _11.844.000 |          1        0.03        2.28
>> _18.000.000 |          9        0.23        3.66
>> _19.456.800 |          1        0.03        3.68
>> _20.000.000 |          8        0.21        3.89
>> __7.500.000 |          3        0.08       17.35
>> __7.600.000 |          1        0.03       17.37
>> __7.820.000 |          1        0.03       17.40
>> __8.000.000 |          5        0.13       17.53
>> __8.300.000 |          1        0.03       17.55
>> __8.400.000 |          3        0.08       17.63
>> __9.000.000 |         10        0.26       17.89
>> __9.200.000 |          1        0.03       17.92
>> __9.600.000 |          6        0.16       18.07
>> __9.800.000 |          1        0.03       18.10
>> __9.850.000 |          1        0.03       18.12
>> ___.100.000 |        102        2.64       20.77
>> ___.100.750 |          1        0.03       20.79
>> ___.100.800 |          1        0.03       20.82
>> ___.102.000 |         22        0.57       21.39
>> ___.102.500 |          2        0.05       21.44
>> ___.103.000 |          1        0.03       21.47
>> ___.103.760 |          1        0.03       21.49
>> ___.104.400 |          2        0.05       21.55
>> ___.104.500 |          1        0.03       21.57
>> *
>> *   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/
>



-- 
Susan Olivia

Research Fellow

Department of Econometrics & Business Statistics
Monash University, Clayton Campus
VIC 3800, Australia

T: +61 3 9905 2081
F: +61 3 9905 5474
E: [email protected]

*
*   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–2018 StataCorp LLC   |   Terms of use   |   Privacy   |   Contact us   |   Site index