How would you delete observations with duplicate keys?
Answer Posted / haritha
In data step first dot variable and last dot variable use
to delete the duplicate values.
by using no dup we delete the duplicate values in row wise
and no dup key is used to delete the duplicate values in
column wise it means observation
and distinct is use to delete the duplicate values in proc
sql
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
explain what is data set in sas? : Sas-administrator
what are the scrubbing procedures in sas? : Sas programming
What is PDV?
What is the use of %include statement?
For what purpose would you use the RETAIN statement?
what versions of sas have you used (on which platforms)? : Sas programming
What is the maximum length of the macro variable? : sas-macro
Describe a time when you were really stuck on a problem and how you solved it?
Tell e how how dealt with..
Describe crosslist option in tables statement?
what does the run statement do? : Sas programming
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is the length assigned to the target variable by the scan function?
what is proc Index? and what is proc document?