How would you delete observations with duplicate keys?

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

Question Posted / jaipal reddy

13 Answers
23733 Views
Accenture, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How would you delete observations with duplicate keys?..

Answer / nishant

Use nodupkey option in proc sort

Is This Answer Correct ?

6 Yes

1 No

How would you delete observations with duplicate keys?..

Answer / ganesh

use nodupkey in proc sort automatically the duplicate key
going to delete.

Is This Answer Correct ?

2 Yes

0 No

How would you delete observations with duplicate keys?..

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

How would you delete observations with duplicate keys?..

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

How would you delete observations with duplicate keys?..

Answer / chirag patel

using Nodup you can delete duplicate observation

Is This Answer Correct ?

4 Yes

3 No

How would you delete observations with duplicate keys?..

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

How would you delete observations with duplicate keys?..

Answer / prakash

nodupkey

Is This Answer Correct ?

1 Yes

0 No

How would you delete observations with duplicate keys?..

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 delete observations with duplicate keys?..

Answer / satish

using nodupkey

Is This Answer Correct ?

2 Yes

2 No

How would you delete observations with duplicate keys?..

Answer / tangyoulei

or distinct in proc sql

Is This Answer Correct ?

2 Yes

2 No

Post New Answer