Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete duplicate observations?
- 10 Answers
- 32797 Views
- Accenture, I also Faced
- E-Mail Answers
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 does sas handle missing values in functions? : Sas programming
What are types of transport files?
What are the features of SAS?
How do dates work in sas?
what is the difference between floor and ceil functions in sas? : Sas-administrator
What is a put statement?
In SAS explain which statement does not perform automatic conversions in comparisons?
What do the mod and int function do? : Sas programming
what can you learn from the sas log when debugging? : Sas programming
Are you involved in writing the inferential analysis plan? Tables specifications?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what is change analysis in sas di ? : Sas-di
Why double trailing @@ is used in input statement?
Explain append procedure?
how many display types available in sas bi dashboard? : Sas-bi
