How would you delete duplicate observations?
- 10 Answers
- 30874 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
Briefly explain input and put function?
which features do you use to check the data validations and errors? : Sas-administrator
how does sas handle missing values in functions? : Sas programming
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What are symget and symput? : sas-macro
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is the role of sas grid administrator? : sas-grid-administration
how does sas handle missing values in sort order? : Sas programming
What does the trace option do?
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
What is maximum storage capability of SAS?
Define run-group processing?
Differentiate between ceil and floor functions.
What are the difference between ceil and floor functions in sas?
What is the difference between match merge and one to one merge?
