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
How to limit decimal places for variable using proc means?
How long can a macro variable be? A token? : sas-macro
What are the new features included in the new version of SAS Programming Language?
What is the different between functions and PROCs that calculate the same simple descriptive statistics?
What are the different types of sas functions?
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
Do you know the features of sas?
How does the internal authentication work in sas? : sas-grid-administration
Explain how merging helps to combine data sets.
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
what is the purpose of _error_? : Sas programming
explain what is factor analysis? : Sas-administrator
What are the default statistics for means procedure?
What commands are used in the case of including or excluding any specific variables in the data set?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake