How would you delete duplicate observations?
Answer Posted / mehul thakkar
There are two ways of deleting the records from the dataset
with the help of PROC SORT.
1. Using NODUP/NODUPRECS
2. Using NODUPKEY
The first option deletes the records only if all the
variables values are repeated in the subsequent records.
The second options deletes the records only if the value of
the BY variables given in the BY clause are repeated in the
subsequent records.
Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are the different versions of sas that you have used until now? : sas-grid-administration
What are the ways in which macro variables can be created in sas programming?
Are you involved in writing the inferential analysis plan? Tables specfications?
What are the implications?
what is the difference between nodup and nodupkey options? : Sas programming
What is the difference between where and if statement?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What are the statements that are executed only?
Which command is used to save logs in the external file?
what is hierarchy flattening? : Sas-di
describe about metadata object? : Sas-di
how does sas handle missing values in procs? : Sas programming
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is metadata? : Sas-bi
what is the difference between infile and input? : Sas-administrator