How would you delete duplicate observations?
- 10 Answers
- 30469 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / poornima
we can delete duplicate observations by using nodup or
nodupkey option in the proc sort
Example :-
Proc sort data=datasetname nodup;
run;
| Is This Answer Correct ? | 33 Yes | 12 No |
Post New Answer View All Answers
Describe the ways in which you can create macro variables?
how will you location sas platform applications available from web browser? : Sas-bi
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is the purpose of _error_? : Sas programming
do you prefer proc report or proc tabulate? Why? : Sas programming
How would you include common or reuse to be processed along with your statements?
Give some examples where proc report’s defaults are different than proc print’s defaults?
what is slowly changing dimension? : Sas-di
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
Explain input and put function?
what are some good sas programming practices for processing very large data sets? : Sas programming
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What are the table names in oracle database...?
what is the difference between nodup and nodupkey options? : Sas programming
How can you create a macro variable with in data step? : sas-macro
