what are methods to identify duplicate observations?
- 5 Answers
- 10125 Views
- HCL, I also Faced
- E-Mail Answers
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 |
which stats created by proc means that are not created by proc summary or vice versa?
How to write duplicate records into a separate dataset using sort?
how to change the execute of macro
What are the difficulties u faced while doing vital signs table or dataset?
What are the prime responsibilities of data integration administrator? : Sas-di
what are _numeric_ and _character_ and what do they do? : Sas programming
What is the difference between informat and format statement?
What are all the problems you faced while validating tables and reports?
0 Answers Accenture, Quintiles,
What is maximum storage capability of SAS?
I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...
How to import the Zip files into SAS? If it is possible in SAS? If it is posible write the code...
The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
Teradata 
