Date:         Mon, 19 May 2003 09:34:18 -0400
Reply-To:     Jay Weedon <jweedon@EARTHLINK.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jay Weedon <jweedon@EARTHLINK.NET>
Organization: http://extra.newsguy.com
Subject:      Re: Retain question
Content-Type: text/plain; charset=us-ascii

On 19 May 03 09:24:10 GMT, geekaxl@21CN.COM (axl) wrote:

>Hello, SAS-L,
>
>        i have a dataset like this :
>
>data test;
>        input  ID_A ID_B;
>        cards ;
>        1 2
>        1 2
>        1 2
>        1 3
>        1 3
>        2 4
>        2 4
>        2 4
>        2 6
>        2 6
>        2 6
>run;
>
>        i want to have a roll-up data set like this :
>
>ID_A ID_B count
>1       2       3
>1       3       2
>2       4       3
>2       6       3
>
>any suggestions ? i know RETAIN can do this , but i don't know how to code it , Thanx in Advance !

PROC SUMMARY may be more efficient at this than a data step.

JW