Date: Fri, 8 Dec 2000 13:52:54 -0500
Reply-To: "Kilili, Anthony, BMG Direct - Indianapolis"
<Anthony.Kilili@BMGDIRECT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Kilili, Anthony, BMG Direct - Indianapolis"
<Anthony.Kilili@BMGDIRECT.COM>
Subject: Re: Data and Count
Content-Type: text/plain; charset="iso-8859-1"
Here's another way:
Proc sql;
Create table new as
Select distinct _sep_ , _fin_, predict, count(predict) as count
From your.dataset
group by _sep_,_fin_;
Quit;
Proc print data=new; run;
HTH
Anthony
-----Original Message-----
From: barrere Bendia [mailto:bendiabare@NETSCAPE.NET]
Sent: Friday, December 08, 2000 1:41 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Data and Count
Hi there.
Some one could help me to transform the data like this:
_sep_ _fin_ predict
0 0 0.35509
0 0 0.35509
0 0 0.35509
0 0 0.35509
0 1 0.39687
0 1 0.39687
0 1 0.39687
1 0 0.39889
1 0 0.39889
1 0 0.39889
1 0 0.39889
1 1 0.44229
1 1 0.44229
1 1 0.44229
1 1 0.44229
to have data like the following:
_sep_ _fin_ predict
count
0 0 0.35509 4
0 1 0.39687 3
1 0 0.39889 4
1 1 0.44229 4
Just to count repetion number of predict value.
Thanks.
