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;

Which statement does not perform automatic conversions in comparisons?

1192

---

What is the difference between the proc sql and data step?

652

---

What do the PUT and INPUT functions do?

768

---

what are the considerations when picking a SAS/STAT procedure?

2890

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

695

---

---

how do you debug and test your sas programs? : Sas programming

554

---

what is sas data set?

658

---

What’s the difference between var b1 – b3 and var b1 — b3?

814

---

What are the difference between ceil and floor functions in sas?

696

---

How will you generate test data with no input data?

555

---

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

737

---

Can you explain the process of calendar?

629

---

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

4191

---

how can you create zero observation dataset? : Sas programming

627

---

If money were no object, what would you like to do?

2678

---