LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (March 2011, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Thu, 3 Mar 2011 13:18:11 -0800
Reply-To:   Irin later <irinfigvam@YAHOO.COM>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Irin later <irinfigvam@YAHOO.COM>
Subject:   Proc Sort nodupkey for all columns
Content-Type:   text/plain; charset=iso-8859-1

I do a proc sort nodupkey  like below to get rid of exact dups:

Proc sort nodupkey data= CombinedFlags out=ppro.CombinedFlagsnodup; by field1 field 2 .......  field300; run;

Since I need to get rid of exact duplicate records,I have to specify each field in the record as that is what I need : to delete dups records with equal values in the same columns....   Is there any way in syntax in order I could do it without specifying  hundreds of fields?   Thank you in advance!

  Irin

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu