Hello,

When I am writing in 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]]

