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
Comments: To: Jerry <greenmt@gmail.com>
In-Reply-To:  <200711141742.lAEGwOMB000998@mailgw.cc.uga.edu>
Content-Type: text/plain; charset="iso-8859-1"

Jerry ,

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 ;
  Output ;
  Cnt = 0 ;
End ;

Run ;


Toby Dunn

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
>
> Toby,
>
> 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.
>
> Jerry

_________________________________________________________________
Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare!
http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews