"What is the difference between proc sort nodup and proc
sort nodupkey?"

Answer Posted / venkatesh

nodup: it deletes duplicates(column wise duplicates).
nodupkey: it deletes row wise duplicates according to
your by variable;
ex: id name
100 nani
101 ravi
100 nani
101 kali
nodup result:
id name
100 nani
101 ravi
101 kali

nodupkey result
100 nani
101 ravi

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between SAS STATA & SPSS?

681


What are the functions which are used for character handling functions?

617


AE datasets names? how many types?

2076


Name validation tools used in SAS

691


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?

638






What is proc sort?

717


Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?

1467


Give an example where SAS fails to convert character value to numeric value automatically?

608


Can you suggest us materials for sdtm mapping?

4037


please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

1661


What versions of SAS have you used (on which platforms)?

1015


what is the basic structure sas administrator? : Sas-administrator

563


What is slibref?

746


What is the difference between where and if statement?

619


What is by-group processing?

574