[R] date translate in R from SAS

Frank E Harrell Jr f.harrell at vanderbilt.edu
Wed Nov 5 13:41:36 CET 2008


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.
> 
> Can anyone help me with this?
> 
> Much thanks
> Rina
> 
> 	[[alternative HTML version deleted]]
> 

The csv.get function in the Hmisc package makes this easy.

Frank
-- 
Frank E Harrell Jr   Professor and Chair           School of Medicine
                      Department of Biostatistics   Vanderbilt University



More information about the R-help mailing list