search for: adm_date

...; will present the same issue, be it as.Date or anything else. I have a dataset, size > dim(morbidity) [1] 1775683 264 This was read in from a STATA .dta file. The dates have come in as the number of ms from 1960 so I have the following to convert these to usable dates. as.Date(morbidity$adm_date / (100*10*60*60*24), origin="1960-01-01") when I store this as a vector it is near instant, <5 seconds test <- as.Date(etc) when I place it over itself it takes ~20 minutes morbidity$adm_date <- as.Date(etc) when I place the vector over it (so no computation involved), or place...

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

...set, size >> >>> dim(morbidity) >> [1] 1775683 264 >> >> This was read in from a STATA .dta file. The dates have come in as the >> number of ms from 1960 so I have the following to convert these to usable >> dates. >> >> as.Date(morbidity$adm_date / (100*10*60*60*24), origin="1960-01-01") >> >> when I store this as a vector it is near instant, <5 seconds >> test <- as.Date(etc) >> when I place it over itself it takes ~20 minutes >> morbidity$adm_date <- as.Date(etc) >> when I place the v...