How would you delete observations with duplicate keys?

Answer Posted / rohit

You can also use a Proc SQL statement with a Distinct
keyword.

Proc Sql;
Select Distinct tablename.* from tablename;
Quit;

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you debug and test your SAS programs?

1037


Explain by-group processing?

579


what type of graphs we will create(for 2+years candidates)?

1895


What is the differnce between SDTM 3.1.2 to 3.1.1 version

4595


What are the automatic variables for macro? : sas-macro

666






What is the difference between reading data from an external file and reading data from an existing data set?

627


What is the difference between match merge and one to one merge?

676


What commands are used in the case of including or excluding any specific variables in the data set?

581


how to debug and test the sas program? : Sas-administrator

566


What is slibref?

737


Differentiate between ceil and floor functions.

648


what is data governance? : Sas-di

616


How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

736


how do you pull data from equifax?tell me the process?

1370


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

1835