How would you delete observations with duplicate keys?
- 6 Answers
- 10940 Views
- I also Faced
- E-Mail Answers
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
explain the main difference between the nodup and nodupkey options? : Sas-administrator
Are you sensitive to code walk-throughs peer review or QC review?
what are the component of range? : Sas-bi
explain about sas business intelligence? : Sas-bi
How does the internal authentication work in sas? : sas-grid-administration
What are the default statistics for means procedure?
Describe the function and utility of the most difficult SAS macro that you have written?
Describe a time when you were really stuck on a problem and how you solved it?
What do you know about sas data set?
Which function is used to count the number of intervals between two sas dates?
what has been your most common programming mistake? : Sas programming
If money were no object, what would you like to do?
What is the purpose of trailing @ and @@? How do you use them?
what is slowly changing dimension? : Sas-di
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
