How would you delete observations with duplicate keys?
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 |
describe about physical data integration? : Sas-di
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
Describe the ways in which you can create a macro variable?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
If a variable contains only numbers, can it be a character data type?
Explain the difference between using drop = data set option in set and data statement?
Describe a time when you were really stuck on a problem and how you solved it?
how to import HTML files into SAS datasets?
Explain translate function?
what type of graphs we will create(for 2+years candidates)?
what is data governance? : Sas-di
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