| Date: | Mon, 19 May 2003 17:24:10 +0800 |
| Reply-To: | axl <geekaxl@21CN.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | axl <geekaxl@21CN.COM> |
| Subject: | Retain question |
| Content-Type: | text/plain; charset="GB2312" |
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 !
Best regards.
axl
geekaxl@21cn.com
2003-05-19
|