what are methods to identify duplicate observations?
- 5 Answers
- 10144 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
how to generate the test data in sas without input data? : Sas-administrator
Explain what is the use of proc gplot?
Which command is used to perform sorting in sas program?
explain the function of substr in sas? : Sas-administrator
what has been your most common programming mistake? : Sas programming
what is sas olap server? : Sas-di
What are the different servers in sas? : sas-grid-administration
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What is the difference between input and infile statement?
What is the maximum length of the macro variable? : sas-macro
explain the difference between proc means and proc summary?
Explain the special input delimiters used in sas programming.
Mention what is the difference between nodupkey and nodup options?
