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]
st: trying to round values and store in a macro, problem with double/floating precision number storage
From
Woolton Lee <[email protected]>
To
statalist <[email protected]>
Subject
st: trying to round values and store in a macro, problem with double/floating precision number storage
Date
Thu, 5 May 2011 11:44:23 -0400
Hello,
I have a program which creates descriptive statistics using tab1,
summarize and other functions, stores the macros then posts them using
postfile and creates tables that can be cut and pasted easily into a
word document.
For example, a small segment of my program is as follows,
/* continuous variables - CRC */
local vars2 age los tchg costpd rbchg rcchg scchg aneschg phrchg radchg mrict
nmchg clchg orchg msschg othchg;
forvalues x = 1/16 {;
local v: word `x' of `vars2';
/********* insurance by safety net hospital */
forvalues a = 1/4 {;
local i: word `a' of `ins';
sum `v' if vhi_site == "Colorectal" & `i' == 1 & snh == 1;
gen float mn = round(r(mean),0.01);
gen float sd = round(r(sd),0.01);
sum mn;
local mn`v'_snh`i'= r(mean);
sum sd;
local std`v'_snh`i' = r(sd);
drop mn sd;
};
This loop creates the variables mn and sd and rounds the result of the
numbers I want to two decimal places then uses summarize to store
these values into macros. I wonder if there is another more efficient
way to do this? I originally was doing all of the computations with
only macros but I found that I could not round to two decimals without
running into problems where a number like 55.87000000000000000001
would show up in my tables. Is there anyway to make this work doing
the computations with just macros?
Thanks for your help,
Woolton
*
* 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/