Interested to Buy Any Domain ? << Click Here >> for more details...
How would you delete duplicate observations?
- 10 Answers
- 32609 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / srinivas
there 3 options to delete duplicate obs
1. nodup
2. nodupkey
3.noduprec
if a entire record is duplicated in sense we use nodup of
nodup rec in proc sort procedure.
proc sort data=dsn nodup/noduprec;
by var;
run;
if a variable is repeated not a entire record . this time
we use nodupkey
proc sort data=dsn nodupkey;
by var;
run;
ex; in a dataset empid is repeated then use this syn. and
the empid is used in by var statement.
| Is This Answer Correct ? | 19 Yes | 5 No |
Post New Answer View All Answers
How does the internal authentication work in sas? : sas-grid-administration
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
Explain substr function?
What is the difference between %local and %global? : sas-macro
What is a method to debug and test your SAS program?
How to create a permanent sas data set?
What are the scrubbing procedures in sas?
What is the basic syntax of a sas program?
What are the difficulties u faced while doing vital signs table or dataset?
How are numeric and character missing values represented internally?
Which date function advances a date, time or datetime value by a given interval?
explain the use of % includes a statement in sas? : Sas-administrator
what is sas database server? : Sas-di
Explain the use of proc gplot? : sas-grid-administration
For clinical entire study how many tables will create approx?
