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
"Vitorino, Maria Ana" <[email protected]>
To
"<[email protected]>" <[email protected]>
Subject
Re: st: Data format query
Date
Tue, 24 May 2011 05:23:06 +0000
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/