Re: [R] date translate in R from SAS

From: Peter Dalgaard <P.Dalgaard_at_biostat.ku.dk>
Date: Wed, 05 Nov 2008 11:14:38 +0100

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

______________________________________________
R-help_at_r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Received on Wed 05 Nov 2008 - 10:18:37 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Wed 05 Nov 2008 - 10:30:22 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive