How would you delete duplicate observations?

Answer Posted / mohan reddy

NODUP OR NODUPREC OPTION IN PROC SORT STATEMENT.
EX;
PROC SORT DATA=EMP NODUP;
RUN;

NODUPKEY OPTION WILL ALSO DELETE THE DUPLICATE OBSERVATION
VALUES.BUT IT CAN USE THE BY VARIABLE.

EX

PROC SORT DATA=EMP NODUPKEY;
BY ENO;
RUN;

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

why is sas data integration studio important? : Sas-di

778


explain what is factor analysis? : Sas-administrator

815


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

849


Explain substr function?

792


What are the default statistics for means procedure?

885


What is interleaving in SAS?

859


Name some categories in sas 9? : sas-grid-administration

742


What is the difference between order and group variable in proc report?

1127


What is program data vector (pdv)?

848


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1674


For what purposes have you used sas macros? : sas-macro

764


What are the different servers in sas? : sas-grid-administration

831


What is the difference between SAS functions and procedures?

888


what is function of retain statment

1785


What are the different operating system platforms in which we can use sas? : sas-grid-administration

805