what are methods to identify duplicate observations?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do the in= variables improve the capability of a merge? : Sas programming

943


Explain the special input delimiters used in sas programming.

589


what is sas and what are the functions? : Sas-administrator

544


what is the use of sas management console? : Sas-di

615


What is Linear Regression?

689






What do you know about sas data set?

600


what is the difference between floor and ceil functions in sas? : Sas-administrator

708


Describe 5 ways to do a “table lookup” in SAS?

705


What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro

585


Enlist the syntax rules followed in sas statements.

621


what are several options for creating reports in web report studio? : Sas-bi

634


What are the automatic variables for macro? : sas-macro

679


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

1918


what is snowflake schema? : Sas-di

698


What is the difference between class statement and by statement in proc means?

663