Date: Thu, 26 Apr 2007 10:18:52 -0400
Reply-To: Rathindronath <mehedisas@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Rathindronath <mehedisas@YAHOO.COM>
Subject: A COUNT PROBLEM
I have a following Dataset:
subject visit
------- -----
001 screening
001 Week 1
001 Week 5
001 Week 5
001 Week 9
002 screening
002 Week 1
002 Week 6
002 Week 6
002 Week 10
I need the following result with counts:
subject visit visit1
------- ----- ------
001 screening -1
001 Week 1 1
001 Week 5 2
001 Week 5 2
001 Week 9 3
002 screening -1
002 Week 1 1
002 Week 6 2
002 Week 6 2
002 Week 10 3
Thanks a lot.
|