How would you delete observations with duplicate keys?
- 13 Answers
- 27164 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ganesh
use nodupkey in proc sort automatically the duplicate key
going to delete.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ganesh
we can delete the observation by using NODUP.
proc sort data=name nodup;
by varname;
run;
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / 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 |
Answer / chirag patel
using Nodup you can delete duplicate observation
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / roopanwita
There is stage called Remove Duplicate to delete duplicate
record and also Sort stage do same funtion.Otherwise if
source databse is a table,then in source SQL we can select
distinct value.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How would you invoke a macro? : sas-macro
Explain the difference between nodup and nodupkey options?
how do you read binary data in sas?
what is treatment emergent events and treatment emregent adverse event
how to debug and test the sas program? : Sas-administrator
if i having variables named a b c d e f ,how to find total of each variable ????give syntax...??
How do you connect the desktop application to metadata server? : sas-grid-administration
how can u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
what is the difference between proc means and proc summary?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
How many missing values are available? When might you use them?
Describe the ways in which you can create macro variables?
Teradata 
