Re: [R] Importing data from MS EXCEL (.xls) to R XXXX

Hi Dan, You can save your .xls as .csv, set up your directory under the file where you saved it, then widge= read.csv("WidgeOne.csv", header=T) It should work. Kathleen. > From: jorgeivanve...@gmail.com > Date: Wed, 24 Aug 2011 18:31:21 -0400 > To: dan.abne...@gmail.com > CC: r-help@r

[R] Creating new variable with maximum visit date by group_id

Dear R users, I am encoutering the following problem: I have a dataset with a 'unique_id' and different 'visit_date' (formatted as.Date, "%d/%m/%Y") per unique_id. I would like to create a new variable with the most recent date of visit per unique_id as shown below. unique_id visit_date