search for: id1564271

Displaying 1 result from an estimated 1 matches for "id1564271".

Did you mean: id1564270
2007 Feb 20
1
Reshape (pivot) question
...6 12:00 5555 1 NA ID1564264 1365 14.2.2006 14:35 5555 1 50 ID1564265 1342 7.4.2006 14:30 2222 2 50 ID1564266 1648 7.4.200614:30 2222 2 50 ID1564267 1263 10.2.2006 15:45 2222 2 10 ID1564267 1263 10.2.200615:45 3333 3 10 ID1564269 5646 13.5.2006 17:02 3333 3 10 ID1564270 7561 13.5.200617:02 6666 1 10 ID1564271 1676 15.5.2006 20:41 2222 2 20 How can I do a new (pivot?) data.frame in R which I can achieve by MS SQL: select eala, datepart(month, date) as month, datepart(year, date) as year, count(distinct id) as id_count, count(distinct patient_id) as patient_count, count(distinct(case when class =...