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: How to convert number format


From   James Sams <sams.james@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: How to convert number format
Date   Thu, 3 Nov 2011 22:52:40 -0500

Given the variable is called v2, i think this will do the trick. Only tested 
with positive numbers.

replace v2 = v2/10^(floor(log10(v2))-2) if v2 >= 1000

-- 
James Sams
sams.james@gmail.com

On Thursday, November 03, 2011, you wrote:
> HI ,
> 
> I apologize for the asking this question
> 
> I have a list of numbers as observations for a variable like
> 
> 20
> 43
> 200
> 298
> 888
> 4619
> 5311
> 5312
> 20210
> 20218
> 
> How do I convert the numbers more than 3 digits(> 999) to have decimal
> after the third digit , i.e., Convert  4619 -->461.9;convert 5311-->531.1;
> 20210-->201.10;20218-->202.18 and leave the two digit and three digit
> numbers as they are i.e., leave 20,43,298 etc as they are 
> Thanks
> Anwar
> 
> 
> *
> *   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