search for: wgtage

Displaying 1 result from an estimated 1 matches for "wgtage".

Did you mean: stage
2011 Apr 13
1
Decimals in R/SQL
...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]]