Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete duplicate observations?
- 10 Answers
- 32614 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
Mention few capabilities of sas framework.
What is the differnce between SDTM 3.1.2 to 3.1.1 version
Which are the statements whose placement in the data step is critical?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
What makes sas stand out to be the best over other data analytics tools?
Can you execute a macro within a macro? Describe. : sas-macro
what is null hypothesis? why do you consider that?
Differentiate between proc means and proc summary.
what is snowflake schema? : Sas-di
How to create an external dataset with sas code?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
what is the use of proc sql? : Sas programming
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
how could you generate test data with no input data? : Sas programming
