how do we get duplicate observations in a separate dataset?
- 6 Answers
- 13401 Views
- CitiGroup, I also Faced
- E-Mail Answers
Answer Posted / rajaanku11
First sort them in descending order and then using first.var
separate all the first observations into a new dataset and
the remaining into another. So unique observations from each
group
will come into one dataset and the other duplicate
observations will enter into another dataset.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the use of %include statement?
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What are symget and symput? : sas-macro
what is operational data and operational system? : Sas-di
What do the SAS log messages "numeric values have been converted to character" mean?
What is maximum number of rows and cols can be handled in SAS?
why a stop statement is needed for the point= option on a set statement?
how does sas handle missing values in a merge? : Sas programming
Difference between nodup and nodupkey options?
Describe the ways in which you can create macro variables? : sas-macro
Explain data_null_?
If you could design your ideal job, what would it look like?
what is transformation in sas data integration? : Sas-di
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what are sas bi dashboard components? : Sas-bi
