Example: bankruptcy
Noduprecs
Found 2 free book(s)
037-30: The Mystery of the PROC SORT Options NODUPRECS …
support.sas.comThe NODUPRECS (or NODUP) and NODUPKEY options can be useful with the SORT procedure but they can be dangerous if you do not understand them completely. They work similarly in that they both can eliminate unwanted observations, but NODUPRECS compares all the variables in your data set while NODUPKEY compares just the BY variables.
Removing Duplicates Using SAS®
support.sas.comNODUPRECS, and . NODUPKEYS. Specifying the DUPOUT= Option . PRO SORT’s . DUPOUT= option can be used to identify duplicate observations before actually removing them from a data set. The DUPOUT= option is used with either the NODUPKEYS or NODUPRECS option to name a data set that will contain duplicate keys or duplicate observations.