what are methods to identify duplicate observations?

Answers were Sorted based on User's Feedback



what are methods to identify duplicate observations?..

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

what are methods to identify duplicate observations?..

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

what are methods to identify duplicate observations?..

Answer / sudha ramalingam

You can also use nodupkey and noduprecs in your proc sort

Is This Answer Correct ?    3 Yes 0 No

what are methods to identify duplicate observations?..

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

what are methods to identify duplicate observations?..

Answer / rag_uss

use nodupkey,noduprecs,freq,distinct in sql

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SAS Interview Questions

Have you been involved in editing the data or writing data queries?

1 Answers   BioServe, Oracle, Sasken,


what is the difference between infile and input? : Sas-administrator

0 Answers  


what is _error_?

2 Answers   Axis Bank, Cognizant, JPMorgan Chase,


how would you determine the number of missing or nonmissing values in computations? : Sas programming

0 Answers  


how to handle in stream data containing semicolon in it?

3 Answers  






WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION?

3 Answers   IBM, Zensar,


What is the length assigned to the target variable by the scan function?

0 Answers  


SAS System ?

5 Answers  


Does anybody has SAS Platform Administration certification dumps. pls send to hariithepalli@gmail.com

0 Answers  


What makes sas stand out to be the best over other data analytics tools?

0 Answers  


What is difference between sas rename and lable?

4 Answers  


how to generate means for every subject;

4 Answers   Mind Tree,


Categories