How would you delete observations with duplicate keys?
Answer Posted / thirumalesh
NoDupKey is to delete duplicate observations based on by variables as a key variable, Noduprecs is to delete multiple observations with same values(repeated values).
also it can be done using proc sql,
and using fist and last statements in if condiotion.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can you suggest us materials for sdtm mapping?
What are all the problems you faced while validating tables and reports?
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
what is the difference between nodup and nodupkey options? : Sas programming
explain the key concept of sas? : Sas-administrator
What does the trace option do?
What are the default statistics for means procedure?
what are all the reports you generated in your recent project?
How do you define proc in sas? : sas-grid-administration
Compare sas with other data analytics tools.
What are the statements that are executed only?
What is run-group processing?
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Explain data_null_?
if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation