Answer Posted / dilip

proc sort data=x out=y;
by v;
data m;
set y;
by v;
if first.v and last.v then delete;
run;


this is for extracting duplicate observations
from a dataset

What sas features do you use to check errors and data validation?

1266

---

Explain why double trailing @@ is used in input statement?

1116

---

how does sas handle missing values in sort order? : Sas programming

981

---

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1056

---

for whom is sas data integration studio designed? : Sas-di

1062

---

what is the effect of the options statement errors=1? : Sas programming

1104

---

what is sas enterprise intelligence architecture? : Sas-bi

1021

---

how do you want missing values handled? : Sas programming

1014

---

What is the general format of function in sas? : sas-grid-administration

1029

---

what is sas data set?

1150

---

What is the purpose of trailing @ and @@? How do you use them?

1088

---

describe about metadata object? : Sas-di

1123

---

For clinical entire study how many tables will create approx?

2020

---

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

1237

---

Mention some common errors that are usually committed in sas programming.

1105

---