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;

Explain data step in SAS

1029

---

What do you code to create a macro? : sas-macro

1079

---

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1011

---

do you need to know if there are any missing values? : Sas programming

996

---

How we can call macros with in data step? : sas-macro

1068

---

What versions of SAS have you used (on which platforms)?

1466

---

What is the maximum and minimum length of macro variable

1179

---

What is the use of function Proc summary?

1223

---

what type of graphs we will create(for 2+years candidates)?

2256

---

How to create list output for cross-tabulations in proc freq?

1068

---

what is hierarchy flattening? : Sas-di

1039

---

What are the data types that sas contain?

1128

---

Name and describe few sas character functions that are used for data cleaning in brief.

1071

---

Differentiate between proc means and proc summary.

1008

---

Do you know the features of sas?

1000

---