diff between nodup rec and ondup key???

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

How to test the debugging in sas?

0 Answers  


How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,


explain the function of substr in sas? : Sas-administrator

0 Answers  


When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 Answers  


What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

0 Answers  






what is broad cast agent? : Sas-bi

0 Answers  


why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,


We have a string like this "kannafromsalembut" ,from this i want to get only "fromsal" (but one condition with out using substring function)here we can not use scan because in the given string there is no delimeter? so give ans without out using substring ?

5 Answers  


what do the pad and dim functions do? : Sas programming

0 Answers  


You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?

2 Answers  


I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  


what are scrubing procedures in SAS?

1 Answers   Oracle,


Categories