How would you delete duplicate observations?
Answer Posted / padmasri
In 3 ways we can delete the duplicate records.
1.procedure proc sort
in proc sort there are two ways to delete duplicate
observations:
* nodupkey
*noduprec
2.first. and last.
3.proc sql
these 3 ways we can delet the duplicate records in sas.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
what do you mean by data staging area? : Sas-di
what is business intelligence? : Sas-bi
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What is a method to debug and test your SAS program?
How many ways to overcome a missing values???
How to test the debugging in sas?
what is star schema? : Sas-di
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What can be the size of largest dataset in SAS?
Difference between informat and format?
In ARRAY processing, what does the DIM function do?
how to generate the test data in sas without input data? : Sas-administrator
what are the scrubbing procedures in sas? : Sas programming
What can you learn from the SAS log when debugging?
Describe the function and untility of the most difficult SAS macro that you have written.