Sign Up Login


  1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

diff between nodup rec and ondup key???

Question Posted / sumith.varma88@gmail.com

Answers were Sorted based on User's Feedback



diff between nodup rec and ondup key???..

Answer / mallikarjuna

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

Is This Answer Correct ?    13 Yes 1 No

diff between nodup rec and ondup key???..

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.

Is This Answer Correct ?    5 Yes 0 No

diff between nodup rec and ondup key???..

Answer / srinu

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

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More SAS Interview Questions

is data integration and etl programming is same? : Sas-di

0 Answers  

What statement do you code to tell SAS that it is to write to an external file? What statement do you code to write the record to the file?

2 Answers   Accenture,

What is the difference between using drop = data set option in data statement and set statement?

0 Answers  

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

0 Answers  

Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

0 Answers  

How to convert a numeric variable to a character variable?

0 Answers  

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 Answers  

how does sas handle missing values in an update? : Sas programming

1 Answers  

Where do the database management systems store data and how do u import them.

2 Answers   L&T,

How to get part of string form the source string without using sub string function in SAS?

3 Answers  

What is the role of sas grid administrator? : sas-grid-administration

0 Answers  

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

0 Answers  

For more SAS Interview Questions Click Here
Categories