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 different between functions and PROCs that calculate the same simple descriptive statistics?
what is the use of sas management console? : Sas-di
What is SAS informats?
Which command is used to save logs in the external file?
Give e an example of..
Explain the difference between informat and format with an example.
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What do you know about sas and what we do? : sas-grid-administration
What are pdv and it functions?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
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?
How long can a macro variable be? A token? : sas-macro
Describe a time when you were really stuck on a problem and how you solved it?
How do you delete duplicate observations in sas?
how do you pull data from equifax?tell me the process?