How to write duplicate records into a separate dataset using
sort?

Answer Posted / charan araveti

if u dont want to use DUPOUT,hear is some code:

data dup(drpo temp_id);
set ds1;
retain temp_id;
if temp_id ne id then
output;
temp_id=id;

Is This Answer Correct ?    1 Yes 3 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

860


Differentiate between proc means and proc summary.

795


how are numeric and character missing values represented internally? : Sas programming

885


what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

786


what is sas data set?

877


What is the difference between SAS functions and procedures?

910


what is the primary data source for the wrs? : Sas-bi

895


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

925


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

2183


What does proc print, and proc contents are used for?

828


What is the basic syntax style in SAS?

863


what is operational data and operational system? : Sas-di

877


Explain what is data step?

940


What is the use of the %include statement?

911


What are the different operating system platforms in which we can use sas? : sas-grid-administration

831