what are methods to identify duplicate observations?
Answers were Sorted based on User's Feedback
Answer / hari prasad reddy
3 methods.
1.using proc sort
2.proc sql distinct
3.set first.var and last.var
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / ramesh sas trainar in stg
1.Proc Sort
2.Proc SQL Distinct
3.first.byvariable
4.last.byvariable
5.proc freq
6.Proc SQL unique
7.merge Statement
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sudha ramalingam
You can also use nodupkey and noduprecs in your proc sort
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / natrajboga
you can Identify the duplicate values by using
1) sort procedure along with the dupout= and nodupkey stmt
options and followed by BY stmt.
2) use the proc sql
for example:
proc sort data=demog dupout=dup_demog nodupkey;
by subjid;
run;
proc sql;
select subjid, count(*) from demog
group by subjid
having count(*)>1;
quit;
Is This Answer Correct ? | 6 Yes | 4 No |
Have you been involved in editing the data or writing data queries?
1 Answers BioServe, Oracle, Sasken,
what is the difference between infile and input? : Sas-administrator
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
how would you determine the number of missing or nonmissing values in computations? : Sas programming
how to handle in stream data containing semicolon in it?
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?
What is the length assigned to the target variable by the scan function?
SAS System ?
Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com
What makes sas stand out to be the best over other data analytics tools?
What is difference between sas rename and lable?
how to generate means for every subject;