Answer / mallikarjuna

nodupkey deletes duplicate observations based on by
variable.
noduprec delete the duplicate observations if entire
observation is duplicate.

Answer / ramkgupta

simply to say nodup and noduprec checks values present in all variables in dataset from one record to next record where as nodupkey checks values present in only variables given in by statement not all variables in a dataset.

Answer / srinu

Hi,
As per my knowledge the key word is wrong in this question "ondup key". I know nodup and nodupkey and dupout.

Please write codes to merge two datasets and keep every record in the first dataset.

1 Answers  

---

how do we mail reports from SAS environment to our team leader

5 Answers   Wockhardt,

---

Mention sas system options to debug sas macros.

0 Answers  

---

Which are the statements whose placement in the data step is critical?

0 Answers  

---

describe how to adjust the performance of data integrator? : Sas-di

0 Answers  

---

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

9 Answers   Quintiles,

---

Which function is used to count the number of intervals between two sas dates?

0 Answers  

---

what is function of retain statment

0 Answers   PPD,

---

Explain substr function?

0 Answers  

---

I have a dataset with variables empid and doj how to calculate retirement age?

1 Answers  

---

differnce between 8.2 and 9.1.3

1 Answers  

---

how to remove the duplicates by proc sql?

2 Answers   Genpact,

---