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 sas data set?

1144

---

Explain data step in SAS

1157

---

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

1080

---

What do the put and input function do?

1107

---

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2286

---

what is sas and what are the functions? : Sas-administrator

1028

---

What is the difference between where and if statement?

1149

---

Mention few capabilities of sas framework.

1237

---

what is the difference between infile and input? : Sas-administrator

1190

---

Explain by-group processing?

1037

---

What are the difficulties u faced while doing vital signs table or dataset?

2446

---

What is the difference between %local and %global? : sas-macro

1233

---

How does proc sql work?

1143

---

what is sas database server? : Sas-di

1189

---

what are the benefits of data integration? : Sas-di

1174

---