what are methods to identify duplicate observations?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how do you debug and test your sas programs? : Sas programming

554


Explain how you can debug and test your SAS program?

559


Define run-group processing?

572


Why and when do you use proc sql?

749


Mention how to limit decimal places for the variable using proc means?

633






how to generate the test data in sas without input data? : Sas-administrator

565


What are the best sas programming practices for handling very large datasets? : sas-grid-administration

556


What is the general format of function in sas? : sas-grid-administration

559


How are numeric and character missing values represented internally?

1131


What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

1991


What is the purpose of trailing @ and @@? How do you use them?

604


How does the internal authentication work in sas? : sas-grid-administration

577


How do you connect the desktop application to metadata server? : sas-grid-administration

574


what are validation tools that are used in sas? : Sas-administrator

586


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

828