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 |
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
What is the use of %include statement?
What is program data vector (pdv) and what are its functions?
What is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
What is the general format of function in sas? : sas-grid-administration
what is the difference between unique key and primary key? : Sas-di
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
what is the difference between the SAS v8 and SAS v9?
What is the order of evaluation of the following operators + - * / ** () ???
what is the use of catalog?
What is your favorite all time computer book? Why?
In which format does Date stores in sas..? What is the use of DATE in SAS.?