Rina Oldager Miehs wrote:> Hi
>
> My dataframe is imported from SAS as a csv file(which cant be any
> different).
>
> There is a vector "dato" that is dates like this:
> 03/12/2004 and that is *day/month/year*.
>
>> vms[1:20,]
> CKRDYRNR RACE_ID datofra minkaelvedato CHRNR cowno
> *dato* opstartdato
> muno timestamp closingtime transtype
> 1 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 03/12/2004 30APR2004 1 03DEC2004:18:54:48.0
> 03DEC2004:19:01:37.0 1
> 2 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 04/12/2004 30APR2004 1 04DEC2004:19:10:29.0
> 04DEC2004:19:15:41.0 1
> 3 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 05/12/2004 30APR2004 1 05DEC2004:18:37:37.0
> 05DEC2004:18:51:23.0 1
> 4 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 06/12/2004 30APR2004 1 06DEC2004:10:18:16.0
> 06DEC2004:10:24:50.0 1
> 5 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 07/12/2004 30APR2004 2 07DEC2004:19:51:52.0
> 07DEC2004:19:56:51.0 1
> 6 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 08/12/2004 30APR2004 1 08DEC2004:23:44:51.0
> 08DEC2004:23:55:21.0 1
> 7 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 09/12/2004 30APR2004 1 09DEC2004:22:01:46.0
> 09DEC2004:22:07:50.0 1
> 8 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 10/12/2004 30APR2004 2 10DEC2004:12:47:56.0
> 10DEC2004:12:59:24.0 1
> 9 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 11/12/2004 30APR2004 1 11DEC2004:23:16:38.0
> 11DEC2004:23:26:50.0 1
> 10 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 12/12/2004 30APR2004 2 12DEC2004:18:30:28.0
> 12DEC2004:18:36:42.0 1
> 11 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 13/12/2004 30APR2004 1 13DEC2004:23:00:28.0
> 13DEC2004:23:06:25.0 1
> 12 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 14/12/2004 30APR2004 1 14DEC2004:13:00:37.0
> 14DEC2004:13:05:29.0 1
> 13 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 15/12/2004 30APR2004 2 15DEC2004:20:01:36.0
> 15DEC2004:20:06:17.0 1
> 14 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 16/12/2004 30APR2004 2 16DEC2004:14:53:20.0
> 16DEC2004:14:59:49.0 1
> 15 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 17/12/2004 30APR2004 1 17DEC2004:15:31:20.0
> 17DEC2004:15:38:17.0 1
> 16 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 18/12/2004 30APR2004 1 18DEC2004:20:19:07.0
> 18DEC2004:20:25:05.0 1
> 17 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 19/12/2004 30APR2004 1 19DEC2004:18:33:58.0
> 19DEC2004:18:41:11.0 1
> 18 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 20/12/2004 30APR2004 1 20DEC2004:13:12:09.0
> 20DEC2004:13:18:16.0 1
> 19 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 21/12/2004 30APR2004 1 21DEC2004:15:05:20.0
> 21DEC2004:15:13:17.0 1
> 20 8004500307 1203 29OCT2004 03DEC2004 19365 307
> 22/12/2004 30APR2004 1 22DEC2004:14:36:19.0
> 22DEC2004:14:44:28.0 1
>
>
> It is read as a factor by R and I cant find a way to translate them to a
> date class because the functions i can find and have used before on other
> data is mdy.
In R? How?
> Can anyone help me with this?
as.Date( ..., format="%d/%m/%Y")
should do it, I think. (Now, if you had previously done the same thing
with "%m/%d/%Y" I'd be somewhat puzzled as to why you couldn't
generalize it...)
--
O__ ---- Peter Dalgaard ?ster Farimagsgade 5, Entr.B
c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K
(*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918
~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907