if u dont want to use DUPOUT,hear is some code: data dup(drpo temp

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

Question Posted / charan araveti

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

Please Help Members By Posting Answers For Below Questions

for report generation which one you used proc report or data_null_?

7630

How do you delete duplicate observations in sas?

1011

How do you control the number of observations and/or variables read or written?

1194

explain what is factor analysis? : Sas-administrator

1047

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

1138

In sas admin differentiate between roles and capabilities? : sas-grid-administration

941

Where do you use proc means over proc freq?

1054

How would you determine the number of missing or nonmissing values in computations?

1014

what do the pad and dim functions do? : Sas programming

963

What is the SAS data set?

1084

What are the data types in sas?

1004

how to debug and test the sas program? : Sas-administrator

976

How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1301

Difference between sum function and using “+” operator?

1087

how would you create multiple observations from a single observation? : Sas programming

954