How would you delete duplicate observations?

Answer Posted / thirumalesh.e.

We can delete using Proc NoDupkey NoDuprecs and
NoDuplicates, then by Dupsort system option, then
if.first . last, Proc sql, create by select * unique ...

OK.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does the trace option do?

874


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2474


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1522


what is the difference between floor and ceil functions in sas? : Sas-administrator

935


what are the benefits of data integration? : Sas-di

753


What are the scrubbing procedures in sas?

770


What are the difference between sas functions and procedures?

849


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2528


How to convert a numeric variable to a character variable?

871


explain the proc in sas? : Sas-administrator

834


Give some examples where proc report’s defaults are same as proc print’s defaults?

888


how would you determine the number of missing or nonmissing values in computations? : Sas programming

908


where to use sas business intelligence? : Sas-bi

786


for what purpose would you use the retain statement? : Sas programming

814


Explain bmdp procedure?

809