Date: Wed, 14 Nov 2007 17:47:45 +0000
Reply-To: toby dunn <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: toby dunn <tobydunn@HOTMAIL.COM>
Subject: Re: transform data
Content-Type: text/plain; charset="iso-8859-1"
I got send happy there try this data step instead of the one I sent you.
Data Need ;
Set One ;
By ID Code ;
Cnt + 1 ;
If Last.Code Then Do ;
Cnt = 0 ;
Compromise is like telling a lie, it gets easier and easier. Each compromise you make, that becomes your standard.
Perfection doesnt exist, once you reach it, its not perfect anymore. It means something else.
> Date: Wed, 14 Nov 2007 12:42:21 -0500
> From: greenmt@GMAIL.COM
> Subject: Re: transform data
> To: SAS-L@LISTSERV.UGA.EDU; tobydunn@HOTMAIL.COM
> Thanks for the code!
> However, the count of code "B" for ID "3" should be 2, while it's 1 in your
> resulting data set.
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!