search for: ss09

...an 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]]

...e how to confirm that or what to change if it is. I do want to get all columns from the CSV into the data table, so I don't want to filter anything. library(sqldf) setwd("R:\\American Community Survey\\Data\\2009") sqldf("attach 'sqlite' as new") read.csv.sql("ss09pusa.csv" , sql="create table ss09pusa as select * from file" , dbname="sqlite") sqldf("select * from ss09pusa limit 3",dbname="sqlite") I've also tried using the SQL IMPORT command, which I couldn't get working properly, even on a tiny two-fiel...