| Date: | Tue, 3 Nov 2009 08:06:43 -0800 |
|---|
| Reply-To: | ash007 <ramsamyashley@GMAIL.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | ash007 <ramsamyashley@GMAIL.COM> |
|---|
| Organization: | http://groups.google.com |
|---|
| Subject: | remove double |
|---|
|
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Hello Sas-Users,
Is there an option to the PROC SORT so that it become case sensitive
please. so that it remove the first ou the second line.
DATA TABLE_BIDON;
INPUT X1 X2 X3 X4 X5 $; CARDS;
2 5 5 1161 ABELIEN
2 5 5 1161 abelien
82 1 5 1499 ANIEL
;
RUN;
PROC SORT DATA = TABLE_BIDON NODUPKEYS; BY _ALL_; RUN;
Thanks.
ash_rmy.
| 
