what are methods to identify duplicate observations?
- 5 Answers
- 10143 Views
- HCL, I also Faced
- E-Mail Answers
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
Have you used macros? For what purpose you have used? : sas-macro
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
What is the difference between using drop = data set option in data statement and set statement?
Mention the validation tools used in SAS?
what is the use of sas management console? : Sas-di
How to include or exclude specific variables in a data set?
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
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
Describe the function and untility of the most difficult SAS macro that you have written.
Mention what is SAS data set?
Describe a time when you were really stuck on a problem and how you solved it?
how do the in= variables improve the capability of a merge? : Sas programming
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What are the different servers in sas? : sas-grid-administration
what are 5 ways to perform a table lookup in sas? : Sas-administrator
