How would you delete duplicate observations?
Answer Posted / padmasri
In 3 ways we can delete the duplicate records.
1.procedure proc sort
in proc sort there are two ways to delete duplicate
observations:
* nodupkey
*noduprec
2.first. and last.
3.proc sql
these 3 ways we can delet the duplicate records in sas.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What are the default statistics for means procedure?
what is change analysis in sas di ? : Sas-di
How do you add a number to a macro variable? : sas-macro
what are _numeric_ and _character_ and what do they do? : Sas programming
what is the use of proc contents and proc print in sas? : Sas-administrator
what is the difference between nodup and nodupkey options? : Sas programming
explain the function of substr in sas? : Sas-administrator
how the sas basic syntax style described? : Sas-administrator
What is factor analysis?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what does the run statement do? : Sas programming
What does the RUN statement do?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
what is treatment emergent events and treatment emregent adverse event
What are all the problems you faced while validating tables and reports?