How would you delete observations with duplicate keys?
- 6 Answers
- 10489 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
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Explain the difference between using drop = data set option in set and data statement?
What is the work of tranwrd function?
What is the basic structure of a sas program?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
How do dates work in sas?
What are the functions used for character handling?
What is the maximum length of the macro variable? : sas-macro
what are the best practices to process the large data sets in sas programming? : Sas-administrator
Explain bmdp procedure?
Can you explain the process of calendar?
what techniques and/or procs do you use for tables? : Sas programming
how would you determine the number of missing or nonmissing values in computations? : Sas programming
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
