how do we get duplicate observations in a separate dataset?

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


Please Help Members By Posting Answers For Below Questions

for whom is sas data integration studio designed? : Sas-di

638


How can sas program be validated?

661


Can you execute a macro within a macro? Describe. : sas-macro

766


What is the command used to find missing values?

684


What is slibref?

849






Describe the ways in which you can create macro variables?

741


What is the difference between nodupkey and nodup options?

682


How do you use the do loop if you don’t know how many times you should execute the do loop?

870


What does PROC print, and PROC contents do?

846


what is hierarchy flattening? : Sas-di

719


For what purposes have you used sas macros? : sas-macro

611


What is run-group processing?

723


How do you convert basic cube to transaction cube and transaction cube to basic cube?

1877


How to read an input file in sas?

745


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

677