How would you delete observations with duplicate keys?

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

More SAS Interview Questions

describe about physical data integration? : Sas-di

0 Answers  


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

0 Answers   SAS,


Describe the ways in which you can create a macro variable?

0 Answers  


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

0 Answers  


If a variable contains only numbers, can it be a character data type?

0 Answers  


Explain the difference between using drop = data set option in set and data statement?

0 Answers  


Describe a time when you were really stuck on a problem and how you solved it?

0 Answers   Oracle,


how to import HTML files into SAS datasets?

3 Answers   HP,


Explain translate function?

0 Answers  


what type of graphs we will create(for 2+years candidates)?

0 Answers   Accenture, Icon,


what is data governance? : Sas-di

0 Answers  


if reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record

4 Answers   HSBC,


Categories