Answer Posted / natrajboga

you can Identify the duplicate values by using
1) sort procedure along with the dupout= and nodupkey stmt
options and followed by BY stmt.
2) use the proc sql

for example:

proc sort data=demog dupout=dup_demog nodupkey;
by subjid;
run;

proc sql;

select subjid, count(*) from demog
group by subjid
having count(*)>1;
quit;

What is the function of Stop statement in a SAS Program?

1152

---

for what purpose would you use the retain statement? : Sas programming

1096

---

Give e an example of..

2340

---

What is the basic syntax of a sas program?

1207

---

Name some categories in sas 9? : sas-grid-administration

977

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1253

---

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

1156

---

why is a stop statement needed for the point=option on a set statement? : Sas programming

1084

---

For what purpose would you use the RETAIN statement?

1524

---

Of all your work, where have you been the most successful?

4669

---

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

1005

---

What are the different versions of sas that you have used until now? : sas-grid-administration

1339

---

What is connection profile? : sas-grid-administration

1173

---

explain the use of % includes a statement in sas? : Sas-administrator

1005

---

In ARRAY processing, what does the DIM function do?

1175

---