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 does proc print, and proc contents are used for?
Can you execute a macro within a macro? Describe. : sas-macro
What are the ways in which macro variables can be created in sas programming?
What sas features do you use to check errors and data validation?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What is a put statement?
Describe the function and untility of the most difficult SAS macro that you have written.
What is Linear Regression?
how do you pull data from equifax?tell me the process?
How to convert a numeric variable to a character variable?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
How substr function works in sas?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
what are all the reports you generated in your recent project?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??