what are methods to identify duplicate observations?
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
why a stop statement is needed for the point= option on a set statement?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is the SAS data set?
what are some good sas programming practices for processing very large data sets? : Sas programming
What is a method to debug and test your SAS program?
Compare sas with other data analytics tools.
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what other sas products have you used and consider yourself proficient in using? : Sas programming
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Give e an example of..
where to use sas business intelligence? : Sas-bi
which date function advances a date, time or datetime value by a given interval? : Sas programming
what is change analysis in sas di ? : Sas-di
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
What is substr function?