diff between nodup rec and ondup key???

Question Posted / sumith.varma88@gmail.com

3 Answers
10327 Views
AON, Sciformix, I also Faced
E-Mail Answers

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

What is SAS? What are the functions does it performs?

0 Answers

There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?

1 Answers Oracle,

Explain proc univariate?

0 Answers

how to display duplicated observations in a data using base sas.

13 Answers HCL, TCS,

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers

Which statement does not perform automatic conversions in comparisons?

0 Answers

diff between nodup rec and ondup key???

3 Answers AON, Sciformix,

what are some good sas programming practices for processing very large data sets? : Sas programming

0 Answers

State the difference between INFORMAT and FORMAT ?

0 Answers

What are the rows present in protocol Violation table?

2 Answers Accenture, Quintiles,

name some data transformation used in sas di? : Sas-di

0 Answers

What is the maximum length of the macro variable? : sas-macro

0 Answers

For more SAS Interview Questions Click Here