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

What is the use of %include statement?

631


how could you generate test data with no input data? : Sas programming

643


How substr function works in sas?

711


what do you mean by data staging area? : Sas-di

611


Explain substr function?

590






What are SAS/ACCESS and SAS/CONNECT?

644


How sas treats the dsd delimiters?

732


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

587


What is the difference between class statement and by statement in proc means?

669


What is the basic structure of the SAS base program?

696


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

651


how will you locate the sas platform applications? : Sas-bi

590


How do you delete duplicate observations in sas?

588


What does the trace option do?

676


What is data _null_?

707