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;

State the difference between INFORMAT and FORMAT ?

1094

---

How would you define the end of a macro? : sas-macro

1086

---

What is Linear Regression?

1159

---

Difference between nodup and nodupkey options?

1184

---

What is the differnce between SDTM 3.1.2 to 3.1.1 version

5070

---

Tell me more about the parameters in macro? : sas-macro

1049

---

How can sas program be validated?

1030

---

What do you know about symput and symget?

1223

---

what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi

1014

---

what versions of sas have you used (on which platforms)? : Sas programming

1066

---

what are sas/access and sas/connect? : Sas programming

989

---

how many types of prompts are there? : Sas-bi

1072

---

where to use sas business intelligence? : Sas-bi

1077

---

Which command is used to perform sorting in sas program?

1043

---

What are the difference between the sas data step and sas procs?

1179

---