How would you delete duplicate observations?

Answer Posted / vijay

There are several ways to do this. However the easliest
code-wise is to use PROC SORT. For example:

PROC SORT DATA=mydata NODUPKEY;
BY variable;
RUN;

Is This Answer Correct ?    17 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is transformation in sas data integration? : Sas-di

650


Tell e how how dealt with..

1869


Have you ever used the SAS Debugger?

1322


what do the pad and dim functions do? : Sas programming

656


Compare sas with other data analytics tools.

682






How to limit decimal places for variable using proc means?

689


What function CATX syntax does?

777


What does PROC print, and PROC contents do?

846


explain the difference between proc means and proc summary?

772


Name types of category in which SAS Informats are placed?

836


what are _numeric_ and _character_ and what do they do? : Sas programming

777


What do the PUT and INPUT functions do?

883


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

884


How do you add a number to a macro variable? : sas-macro

638


Difference between informat and format?

742