diff between nodup rec and ondup key???
Answers were Sorted based on User's Feedback
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 |
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 |
How to test the debugging in sas?
How experienced are you with customized reporting and use of Data _Null_ features?
explain the function of substr in sas? : Sas-administrator
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?
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
what is broad cast agent? : Sas-bi
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
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 ?
what do the pad and dim functions do? : Sas programming
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?
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?
what are scrubing procedures in SAS?