what are methods to identify duplicate observations?

Answer Posted / rag_uss

use nodupkey,noduprecs,freq,distinct in sql

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between reading data from an external file and reading data from an existing data set?

871


If a variable contains only numbers, can it be a character data type?

828


I have a dataset concat having a variable a b & c. How to rename a b to e & f?

985


What are the applications primarily used by business analyst? : Sas-bi

741


What would be the value of month at the end of data step execution and how many observations would be there?

778






Name and describe few sas character functions that are used for data cleaning in brief.

860


Describe a time when you were really stuck on a problem and how you solved it?

2402


What is the maximum and minimum length of macro variable

893


where are dashboard components are created and maintained? : Sas-bi

771


I need level 2 to 5 sas using companies in india

2111


What are the data types does SAS contain?

823


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1352


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2076


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1868


explain the main difference between the nodup and nodupkey options? : Sas-administrator

904