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
Differentiate input and infile.
What is SAS informats?
How necessary is it to be creative in your work?
it will become easy if uuu provide website linkssss and list of consultanciessssss
What are the different servers in sas? : sas-grid-administration
Explain the difference between informat and format with an example.
what is the effect of the options statement errors=1? : Sas programming
How would you include common or reuse to be processed along with your statements?
What are the difference between ceil and floor functions in sas?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
Approximately what date is represented by the SAS date value of 730?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
What is the basic syntax of a sas program?
how would you create multiple observations from a single observation? : Sas programming
Explain translate function?