How would you delete observations with duplicate keys?

Answer Posted / haritha

In data step first dot variable and last dot variable use
to delete the duplicate values.
by using no dup we delete the duplicate values in row wise
and no dup key is used to delete the duplicate values in
column wise it means observation
and distinct is use to delete the duplicate values in proc
sql

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Approximately what date is represented by the SAS date value of 730?

853


Name and describe few sas character functions that are used for data cleaning in brief.

753


how to remove duplicates using proc sql?

735


Describe 5 ways to do a “table lookup” in SAS?

792


Intern stastical programmer written test

378






Do you know the features of sas?

695


it will become easy if uuu provide website linkssss and list of consultanciessssss

1633


how to do user inputs and command line arguments in sas?

2519


How would you define the end of a macro?

794


How would you invoke a macro? : sas-macro

650


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

611


what are the types of interactive display types? : Sas-bi

742


How would you include common or reuse to be processed along with your statements?

1998


what is study design in while working with SAS? what are screening variables in SAS?

1796


what is function of retain statment

1677