Transcription of SUGI 25: Removing Duplicates: PROC SQL Can …
{{id}} {{{paragraph}}}
Example: bankruptcy
SUGI 25: Removing Duplicates: PROC SQL Can …
Paper 106-25 Removing DUPLICATES: proc sql can HELP YOU SEE Vicki Siemers, Damark International, Inc., Minneapolis, MNBrian Nash, Conseco Finance Corp., St. Paul, MNAbstractDuplication of information within data sets is a commonoccurrence. Data files may contain duplicate account numbers,telephone numbers, names, etc. A standard/accepted solution forremoving duplicates is the NODUPKEY option of PROC , this procedure is often used blindly. The firstduplicate observation is kept in the data set while all subsequentoccurrences are deleted. But what if the third occurrence shouldhave been kept and the first and second occurrences deleted?PROC SQL, a component of Base SAS, can help SAS usersinvestigate duplicates so that a more informed choice can bemade when deleting observations. This paper is intended forusers with an intermediate SAS programming skill , the first phase in any analysis project is to check theintegrity of the data ( , remove duplicates, ensure valid values,etc.)
Paper 106-25 REMOVING DUPLICATES: PROC SQL CAN HELP YOU “SEE” Vicki Siemers, Damark International, Inc., Minneapolis, MN Brian …
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: