How would you delete duplicate observations?
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
What is the use of the %include statement?
what has been your most common programming mistake? : Sas programming
how can you import .csv file in to sas? : Sas programming
how do you pull data from equifax?tell me the process?
What system options would you use to help debug a macro? : sas-macro
What are the parameters of scan function?
Explain why double trailing @@ is used in input statement?
How would you determine the number of missing or nonmissing values in computations?
what is the use of sas management console? : Sas-di
I have a dataset concat having variable a b & c. How to rename a b to e & f?
What is program data vector (pdv) and what are its functions?
what is enterprise guide? What is the use of it? : Sas programming
Which statement does not perform automatic conversions in comparisons?
how to change the execute of macro
what is null hypothesis? why do you consider that?