How would you delete observations with duplicate keys?

Answer Posted / g.jyotshna

proc sort data=datasetname nodup;
by var;
run;
proc sort data=datasetname nodupkey;
by var;
run;
proc sort data=datasetname noduprecs;
by var;
run;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell e how how dealt with..

1749


What is the role of unrestrictive users? : sas-grid-administration

566


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

532


Name few SAS functions?

660


what has been your most common programming mistake? : Sas programming

550






explain the concepts and capabilities of business object? : Sas-bi

532


What do the mod and int function do? : Sas programming

564


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

827


which date functions advances a date time or date/time value by a given interval? : Sas programming

522


What are the 3 components in sas programming?

714


What are the implications?

1175


how can you import .csv file in to sas? : Sas programming

627


how many types prompting framework can be broken down to? : Sas-bi

616


What can be the size of largest dataset in SAS?

703


How would you invoke a macro? : sas-macro

540