Many thanks for this, I will try this code. Much appreciated. -----Original Message----- From: Peter Dalgaard [mailto:p.dalga...@biostat.ku.dk] Sent: 22 April 2009 22:05 To: David Winsemius Cc: Bronagh Grimes; r-help@r-project.org Subject: Re: [R] Count Code
David Winsemius wrote: > > On Apr 22, 2009, at 3:42 PM, Bronagh Grimes wrote: > >> Hi there, >> I am interested in converting SAS code to R & I wondered if anyone had >> any quick R code/tips for the following piece of test SAS code? >> >> Any feedback greatly appreciated. >> >> data A1; >> set A1; >> count + 1; >> by subject_id; >> if first.subject_id then count = 1; >> run; > > There were several solution offered a couple of months back to the > challenge of replicating the features of the SAS _N_ construct. At least > that is my memory of how it looks in SAS. You probably have the right > books to consult for that question to construct a proper search: I think this one could be count <- ave(a1$subject_id, a1$subject_id, FUN = seq_along) (assuming that "count+1;" increases the value from the previous record.) -- 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.dalga...@biostat.ku.dk) FAX: (+45) 35327907 ______________________________________________ R-help@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.