Displaying 1 result from an estimated 1 matches for "agep".
Did you mean:
age
2011 Apr 13
1
Decimals in R/SQL
...sqldf or RSQLite I lose the decimals in my matrix.
The only way I can get decimals is by multiplying by 1.00000, etc. I
have tried manipulating the options, but it is only effective once I
multiply by 1.0000.
I appreciate any suggestions!
Thanks!
Example:
z <- sqldf ("select ST,
SUM(AGEP*PWGTP)*1.000000000/SUM(PWGTP)*1.00000000000000 as wgtage from
ss09 group by ST")
z shouldn't be whole numbers.
[[alternative HTML version deleted]]