[R] Count Code

Bronagh Grimes Bronagh.Grimes at distinct.ie
Thu Apr 23 10:04:29 CEST 2009


Many thanks for this, I will try this code.  Much appreciated.

-----Original Message-----
From: Peter Dalgaard [mailto:p.dalgaard at biostat.ku.dk] 
Sent: 22 April 2009 22:05
To: David Winsemius
Cc: Bronagh Grimes; r-help at 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.dalgaard at biostat.ku.dk)              FAX: (+45) 35327907




More information about the R-help mailing list