Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
From | "Vitorino, Maria Ana" <vitorino@wharton.upenn.edu> |
To | "<statalist@hsphsun2.harvard.edu>" <statalist@hsphsun2.harvard.edu> |
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/