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
What is the work of tranwrd function?
What do you know about sas data set?
what is treatment emergent events and treatment emregent adverse event
How does proc sql work?
What do you know about symput and symget?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager
Explain the difference between informat and format with an example.
What can you learn from the SAS log when debugging?
What is the difference between where and if statement?
What is PROC in SAS?
what is the basic structure sas administrator? : Sas-administrator
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is a method to debug and test your SAS program?
what is program data vector? : Sas-administrator