Date: Tue, 6 Sep 2005 10:02:39 -0700
Reply-To: Toby <tobydunn@HOTMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Toby <tobydunn@HOTMAIL.COM>
Subject: Re: Find unique records and recode
Content-Type: text/plain; charset="iso-8859-1"
proc sql ;
select first.* , new2 as new
from one as first
(select * , count(*) as new , monotonic(calculated new) as new2
group by old) as second
on first.old = second.old ;
I have one character variable (old).
There are many combinations of "old" variable.
How could I find unique and recode those data to "new"?????