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 has been your most common programming mistake? : Sas programming
which date function advances a date, time or datetime value by a given interval? : Sas programming
How do you define proc in sas? : sas-grid-administration
What is the role of administrative users? : sas-grid-administration
explain the proc in sas? : Sas-administrator
do you need to know if there are any missing values? : Sas programming
what is business intelligence? : Sas-bi
Describe the ways in which you can create macro variables?
What is a method to debug and test your SAS program?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What are pdv and it functions?
What is the use of %include statement?
what are the component of range? : Sas-bi
why a stop statement is needed for the point= option on a set statement?
Mention what are the data types does SAS contain?