Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete duplicate observations?
- 10 Answers
- 32498 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 can I remove header from output data set?
name several ways to achieve efficiency in your program? : Sas programming
how the sas basic syntax style described? : Sas-administrator
What do you code to create a macro? : sas-macro
for whom is sas data integration studio designed? : Sas-di
what is the use of sas management console? : Sas-di
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
Define run-group processing?
What do the PUT and INPUT functions do?
Of all your work, where have you been the most successful?
Explain substr function?
How do you add a number to a macro variable? : sas-macro
what do the pad and dim functions do? : Sas programming
which date functions advances a date time or date/time value by a given interval? : Sas programming
how to debug and test the sas program? : Sas-administrator
