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
What is the use of %include statement?
how could you generate test data with no input data? : Sas programming
How substr function works in sas?
what do you mean by data staging area? : Sas-di
Explain substr function?
What are SAS/ACCESS and SAS/CONNECT?
How sas treats the dsd delimiters?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What is the difference between class statement and by statement in proc means?
What is the basic structure of the SAS base program?
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?
how will you locate the sas platform applications? : Sas-bi
How do you delete duplicate observations in sas?
What does the trace option do?
What is data _null_?