Answer Posted / suresh babu prattipati

hi,
to display the dups in seperate dataset please find the
below program.

eg:
data dups;
input var1;
1
2
3
4
4
3
5
6
;
run;

/*to find the dups*/


data dups1;
set dups;
by var1;
if not(first.var1 and last.var1) then output;
run;

*now you can see the dups ;

If any one have any sas question please e.mail me to

suresh.sasv9@gmail.com

thanks
suresh

What is the use of divide function?

1067

---

what are _numeric_ and _character_ and what do they do? : Sas programming

1156

---

What is a put statement?

1202

---

what are several options for creating reports in web report studio? : Sas-bi

1158

---

What are the special input delimiters used in SAS?

1183

---

what are the component of range? : Sas-bi

1100

---

what is transformation in sas data integration? : Sas-di

1036

---

Define run-group processing?

1047

---

What are the different servers in sas? : sas-grid-administration

1058

---

How do you add a number to a macro variable? : sas-macro

1012

---

what is SAS OPTIMIZATION?

2298

---

describe about metadata object? : Sas-di

1071

---

name some data transformation used in sas di? : Sas-di

972

---

What makes sas stand out to be the best over other data analytics tools?

1072

---

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

1373

---