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;

Give e an example of..

2272

---

Describe what are the different levels of administrative users in sas? : sas-grid-administration

977

---

how do you test for missing values? : Sas programming

989

---

If a variable contains only numbers, can it be a character data type?

1031

---

How are numeric and character missing values represented internally?

1604

---

how do you pull data from equifax?tell me the process?

1741

---

Explain the use of proc gplot? : sas-grid-administration

926

---

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2735

---

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1105

---

how many display types available in sas bi dashboard? : Sas-bi

1029

---

Explain the purpose of substr functions in sas programming.

1003

---

Do you know the features of sas?

993

---

Have you ever used the SAS Debugger?

1690

---

what is the use of proc sql? : Sas programming

1037

---

What are the parameters of scan function?

1102

---