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
Intern stastical programmer written test
To what type of programms have you used scratch macros?
Which function is used to count the number of intervals between two sas dates?
what do you mean by data staging area? : Sas-di
What do the PUT and INPUT functions do?
Tell me about % include and % eval? : sas-macro
what is the difference between unique key and primary key? : Sas-di
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 use the WHO Drug Dictionary for Reporting Clinical Trials?
explain the concepts and capabilities of business object? : Sas-bi
What are the features of base sas system?
List down the reasons for choosing sas over other data analytics tools.
Are you involved in writing the inferential analysis plan? Tables specifications?
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
What are the automatic variables for macro? : sas-macro